IF Statement troubles

[Tina]

I have a list box in F5 with 24, 18,14, 12,10. I need F7 to return if:
24=2400
18=1350
14=816
12=600
10=416

The first part of the below formula works, but I can't get it to work past
that. Could someone please help?

=IF(F5=(24),2400,If(or(f5=(18),1350)))

Thank you!

 

[Bob Phillips]

Try

=VLOOKUP(F5,{24,2400;18,1350;14,816;12,600;10,416},2,FALSE)

 

[Lee Li Fong]

Try this formula
=IF(F5=24,2400,IF(F5=18,1350,IF(F5=14,816,IF(F5=12,600,IF(F5=10,416))))

Blog:http://smartusemicrosoftoffice.blogspot.com/

 

[Joe User]

I have a list box in F5 with 24, 18,14, 12,10.
I need F7 to return if:
24=2400
18=1350
14=816
12=600
10=416

If you are not concerned about errors, try:

=LOOKUP(F5,{10,12,14,18,24},{416,600,816,1350,2400})

The first part of the below formula works,
but I can't get it to work past that. [....]
=IF(F5=(24),2400,If(or(f5=(18),1350)))

FYI, the equivalent IF expression is:

=if(F5=10,416,if(F5=12,600,if(F5=14,816,
if(F5=18,1350,2400))))


----- original message -----