using multiply if function

[lbreger]

I need to create a formula using this information.

Lets say cell G3 is an age 28.4
Than I need in another cell
If G3 is <30 = 1.25
30-40 =1.0

40 = .75

Please help

 

[Keith Faulconer]

Try this:

=if(G3<30,1.25,if(G3<40,1,.75))

I wasn't sure if you wanted 30 to be 1.25 and 40 to be .75. If that is what
you want, then use the <= in place of the < sign.

Hope that helps.

 

[Jacob Skaria]

=LOOKUP(G3,{0,30,41},{1.25,1,0.75})

 

[Bernard Liengme]

=1.25-0.25*(G3>=30)-0.25*(G3>40)
best wishes

 

[Ashish Mathur]

Hi,

You may also try this. In range B26:B28, type 0,30,41. In range C26:C28,
type 1.25,1,0.17. Now type 28.4 in cell B31. In cell C31, enter the
formula =VLOOKUP(B31,B26:C28,2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com