I need some assistance with how to write an Excel formula for the below:
A28 one of the following will be entered: LIN, LOX, LAR, CO2, GH2, GN2 or GO2
Depending on which is entered in cell A28 will have a conversion value that needs to be multiplied by the value in cell D63 and that product to be placed in cell S63
THEN CELL D63 NEEDS TO BE MULTIPLIED BY 13.80
AND THAT PRODUCT PLACED IN CELL S63
LIN = 13.80 LOX = 12.08 LAR = 9.671 CO2 = 1.0 GH2 =1.0 GN2 = 1.0 GO2 = 1.0
Any help is greatly appreciated!