I have a series of lots imported as conditions from a csv file.
I am calculating a transition analysis, which requires the manual input of the packed bed height.
I want to write some kind of formula that says "when lot number = 12345, then bed height=22. When lot number =45678 then bed height=25, etc". Any suggestions?