Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula using IF function
i'm trying to place a formula in a cell using the "IF" function to obtain the
greater value of either: D49-D47 or D49 times 30%. is it possible i'm using the incorrect function? thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula using IF function
Hi
=MAX(D49-D47,0.3*D49) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "bronxbabe" wrote in message ... i'm trying to place a formula in a cell using the "IF" function to obtain the greater value of either: D49-D47 or D49 times 30%. is it possible i'm using the incorrect function? thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula using IF function
WONDERFUL. THANK U VERY MUCH. NOW I CAN GO TO SLEEP!
i'v been recking my brain for the past several hours b/c excel recommended using the IF function -- not MAX. thanks again, 2:53EST "Arvi Laanemets" wrote: Hi =MAX(D49-D47,0.3*D49) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "bronxbabe" wrote in message ... i'm trying to place a formula in a cell using the "IF" function to obtain the greater value of either: D49-D47 or D49 times 30%. is it possible i'm using the incorrect function? thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula using IF function
well, after evaluation, my lengthy IF statement does work:
=IF(D49-D470.3*D49,D49-D47,0.3*D49), but the MAX is easier to read. thanks again, 11:13EST "Arvi Laanemets" wrote: Hi =MAX(D49-D47,0.3*D49) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "bronxbabe" wrote in message ... i'm trying to place a formula in a cell using the "IF" function to obtain the greater value of either: D49-D47 or D49 times 30%. is it possible i'm using the incorrect function? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PV function formula | Excel Discussion (Misc queries) | |||
Help with formula/function | Excel Worksheet Functions | |||
A formula/function to return a formula/function | Excel Worksheet Functions | |||
Formula...function...how to? | Excel Worksheet Functions | |||
A formula for an OR function | Excel Worksheet Functions |