value is "0"
 

What conditional formula should be in cell "C" if I am subtracking column "A"
with column "B", so the value in cell 'C" should be '"0" if the subtraction
is zero or less then zero.

Thank you in advance.

SV

value is "0"
 

=IF(A1-B1<0,0,A1-B1)


"dan" wrote in message
...
What conditional formula should be in cell "C" if I am subtracking column
"A"
with column "B", so the value in cell 'C" should be '"0" if the
subtraction
is zero or less then zero.

Thank you in advance.

SV

value is "0"
 

=MAX(0,A1-B1)
--
David Biddulph

"dan" wrote in message
...
What conditional formula should be in cell "C" if I am subtracking column
"A"
with column "B", so the value in cell 'C" should be '"0" if the
subtraction
is zero or less then zero.

Thank you in advance.

SV