Can I do this?

  • Thread starter Lee and Rebecca
  • Start date
L

Lee and Rebecca

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
[email protected] if you can help. Thanks.
 
R

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
[email protected] if you can help. Thanks.
 
Top