Formula help needed.

  • Thread starter Thread starter Tommy T
  • Start date Start date
T

Tommy T

In Cell E72 I want the result of E66 minus E70.
But if E66 minus E70 is a negative figure I want a 0 to be shown instead
What is the best way to do that in Excel 2000?
Thanks.
Tommy T.
 
Tommy T said:
In Cell E72 I want the result of E66 minus E70.
But if E66 minus E70 is a negative figure I want a 0 to be shown instead
What is the best way to do that in Excel 2000?
Thanks.
Tommy T.
Click to expand...
=MAX(0,E66-E70)
..i
 
=MAX(E66-E70,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
In Cell E72 I want the result of E66 minus E70.
But if E66 minus E70 is a negative figure I want a 0 to be shown instead
What is the best way to do that in Excel 2000?
Thanks.
Tommy T.
Click to expand...

Do you want a 0 to be "shown" or do you want the cell's value to be 0?

If you want the cell's value to "be" a zero, then the MAX formula others have
suggested will work.

If you only want the cell to *show* a zero, but still have the real value
stored within it, then use the custom format: [<0]"0";0.00

You might want to alter the last factor depending on how many decimal places
you want to have in your final result.


--ron
 
Back
Top