ExcelBanter - zero on negative cell

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

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

- - zero on negative cell (https://www.excelbanter.com/excel-discussion-misc-queries/101919-zero-negative-cell.html)

help

zero on negative cell

it is a stupid question but how do you make a cell in excel a zero when it is
a negative calculation and then that same cell to display the positive numbers

Sloth

zero on negative cell

=MAX(formula,0)

"help" wrote:

it is a stupid question but how do you make a cell in excel a zero when it is
a negative calculation and then that same cell to display the positive numbers

All times are GMT +1. The time now is 08:14 AM.