ExcelBanter - replace a negative result with a zero?

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

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

- - replace a negative result with a zero? (https://www.excelbanter.com/excel-discussion-misc-queries/261843-replace-negative-result-zero.html)

Pam2277

replace a negative result with a zero?

I have my formula entered but need it to return a zero if the result is
negative. Any help is greatly appreciated.
--
Pam

Pete_UK

replace a negative result with a zero?

Well, what is the formula that you are using?

You could try this:

=MAX(your_formula,0)

to replace your_formula.

Hope this helps.

Pete

On Apr 19, 5:17*pm, Pam2277 wrote:
I have my formula entered but need it to return a zero if the result is
negative. *Any help is greatly appreciated.
--
Pam

Eduardo

replace a negative result with a zero?

Hi,

=if(your formula<0,0,your formula)

"Pam2277" wrote:

I have my formula entered but need it to return a zero if the result is
negative. Any help is greatly appreciated.
--
Pam

All times are GMT +1. The time now is 05:40 AM.