Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
STEP MULTIPLY FUNCTION | Excel Worksheet Functions | |||
What function will find and multiply specific values in excel? | Excel Worksheet Functions | |||
What function will find and multiply specific values in excel? | Excel Worksheet Functions | |||
keep leading zeros when using the paste spec. multiply function | Excel Discussion (Misc queries) | |||
is there a function that will multiply different cells | Excel Worksheet Functions |