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/126765-re-if-negative-then-show-0-a.html)

Anna

if the # is a negative #, then show 0

assume that your value at cell A1,
=IF(A1<0,0,A1)

" 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:46 AM.