Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement troubles
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Troubles | Excel Discussion (Misc queries) | |||
Formula troubles | Excel Discussion (Misc queries) | |||
COM Add-in Troubles | Excel Discussion (Misc queries) | |||
If, then statement troubles | Excel Worksheet Functions | |||
IF troubles | Excel Worksheet Functions |