Formula help needed.

[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.

 

[ivano]

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.

=MAX(0,E66-E70)
..i

 

[Bob Phillips]

=MAX(E66-E70,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

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.

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

 

[Tommy T]

Thanks to the three of you for your assistance.
Problem now overcome.
Tommy T.