A1=3, A2=4, A2-A1 = 1, A2A1 = TRUE
A1=-3, A4=-4, A2-A1=-1, A2A1=FALSE
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JoeU2004" wrote in message
...
"LCCHELP" wrote:
I have input the following if function
if(at1av1,at1-av1,0)

"Bernard Liengme" wrote:
Your formula should work, assuming we are talking
about positive values in AT1 and AV1

Forgive me if I'm being dense, but what difference does it make whether we
are talking about positive or negative numbers or a mix?


----- original message -----

"Bernard Liengme" wrote in message
...
Your formula should work, assuming we are talking about positive values
in AT1 and AV1
Here is an alternative: =MAX(0,AT1-AV1)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"LCCHELP" wrote in message
...
I have input the following if function

if(at1av1,at1-av1,0) however if the number in av1 is greater than at1
it
returns a negative number, rather than returning 0.

can someone enlighten me as to what I have missed.

thanks