using multiply if function
 

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

using multiply if function
 

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.
"lbreger" wrote in message
...
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

using multiply if function
 

=LOOKUP(G3,{0,30,41},{1.25,1,0.75})
--
If this post helps click Yes
---------------
Jacob Skaria


"lbreger" wrote:

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

using multiply if function
 

=1.25-0.25*(G3=30)-0.25*(G340)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"lbreger" wrote in message
...
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

using multiply if function
 

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

"lbreger" wrote in message
...
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