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

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

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

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