ExcelBanter - How do I find and replace a number with a minus sign in front?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I find and replace a number with a minus sign in front? (https://www.excelbanter.com/excel-discussion-misc-queries/54054-how-do-i-find-replace-number-minus-sign-front.html)

D.Sommer

How do I find and replace a number with a minus sign in front?

Roger Govier

How do I find and replace a number with a minus sign in front?

Hi

We need a bit more information to help.
Are you wanting to return a 0 rather than a negative result from a
calculation?
=MAX(0,A1-B1)

--
Regards

Roger Govier

"D.Sommer" wrote in message
...

All times are GMT +1. The time now is 06:53 PM.