If question

[Jimmy H]

Hi,

Is it possible to enter a range of numbers into an IF statement?

This is what I am trying to do:

if cell A = 0.8:0.999 then return 0.75 of cell B

I need to do this same thing 4 times in the same formula.

This is what I have so far:

=IF(D2>=0.8,(D1*0.75),IF(D2>=1,(D1*1)))

After getting this far, I realize it's not going to work.

Any help or suggestions would be greatly appreciated.

Thanks,

Marc

 

[JE McGimpsey]

One way:

=D1*LOOKUP(D2,{0.8,0.75;1,1;1.2,2;1.4,4})

 

[Jimmy H]

Worked perfectly! Thanks.

One way:

=D1*LOOKUP(D2,{0.8,0.75;1,1;1.2,2;1.4,4})