Prev: Print Button
Next: Find and Replace only the first character
From: Tina on 31 Mar 2010 09:22
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!
From: Bob Phillips on 31 Mar 2010 09:30
Try

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

--

HTH

Bob

"Tina" <Tina(a)discussions.microsoft.com> wrote in message
news:2ACF02B3-F548-4AD7-BF37-487C0BA4BE91(a)microsoft.com...
>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!


From: Joe User on 31 Mar 2010 09:49
"Tina" wrote:
> 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 -----

"Tina" wrote:
> 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!
 | 
Pages: 1
Prev: Print Button
Next: Find and Replace only the first character