Can I do this?

[Guest]

The formula I am using is =I17-40.
What I want is for the cell to show a zero if the result of the formula is
less than zero. In other words, show a zero if the result of the formula is
in the negative. Can I do this. Please e-mail Lee at
(e-mail address removed) if you can help. Thanks.

 

[Guest]

=if(I17-40>0,I17-40,0)

 

[RagDyeR]

Try this:

=MAX(I17-40,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


The formula I am using is =I17-40.
What I want is for the cell to show a zero if the result of the formula is
less than zero. In other words, show a zero if the result of the formula is
in the negative. Can I do this. Please e-mail Lee at
(e-mail address removed) if you can help. Thanks.

 

[Guest]

Thanks to all. That worked.