If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
using multiply if function
Try this:
=if(G330,1.25,if(G340,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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|