ExcelBanter - if the # is a negative #, then show 0

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

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

- - if the # is a negative #, then show 0 (https://www.excelbanter.com/excel-discussion-misc-queries/126832-if-negative-then-show-0-a.html)

[email protected]

if the # is a negative #, then show 0

I cant seem to figure out how to make a formula that when it performs its
calculation and the answer is a negative #, i want it to just show "0".
Is it a IF command?

thanks

Stefi

if the # is a negative #, then show 0

=MAX(0;yourformula)

Regards,
Stefi

€ ezt Ã*rta:

I cant seem to figure out how to make a formula that when it performs its
calculation and the answer is a negative #, i want it to just show "0".
Is it a IF command?

thanks

Mike

if the # is a negative #, then show 0

This could get you into difficulties if you intend to perform further
calculations on an answer that is now incorrect but here you go

=IF(B14-A14<0,0,B14-A14)

assumes you are subtracting B14 from A14. Modify to suit.

" wrote:

I cant seem to figure out how to make a formula that when it performs its
calculation and the answer is a negative #, i want it to just show "0".
Is it a IF command?

thanks

All times are GMT +1. The time now is 02:37 AM.