View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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