Creating a cost estimate sheet. I have five parameters and each one has 16
parameters. I can use lookup
=LOOKUP(A3,{1,4,5,6,7,8,10,12,14,16,18,20,22,24,30 ,36},{1.08,1.23,1.45,1.62,2,2.46,2.85,4.24,4.7,5.2 5,5.8,6.3,9.55,11.45"})
for one but this formula has five versions each with different pricing.
therefore I am trying to make an if formula something like
=IF(A2=1,"=LOOKUP(A3,{1,4,5,6,7,8,10,12,14,16,18,2 0,22,24,30,36},{1.08,1.23,1.45,1.62,2,2.46,2.85,4. 24,4.7,5.25,5.8,6.3,9.55,11.45})",IF(A2=2,"B",
IF(A2=3,"C",IF(A2=4,"D","F")))) Problem though is it takes the answer as text
and not another formula ideas solutions or am overloading the program.