Hi all,

Is there any way to automatically change any negative numbers in a

cell to zero? For a spend down spreadsheet that I am developing, any

negative numbers will be zero. I could not find a format or function

that would do it. I would like to avoid the =if(.......>0,......,0)

route because the formula in the cell already contains an if argument

and it is already too complicated. Would an array formula work? I

haven't worked with them too much. Any advice is appreciated.

TIA

Chet

## Bookmarks