using multiply if function

  • Thread starter Thread starter lbreger
  • Start date Start date
L

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
Click to expand...

Please help
 
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.
 
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.
 
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
 
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
 
Back
Top