View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tina tina is offline
external usenet poster
 
Posts: 139
Default 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!