View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay M 0425 Jay M 0425 is offline
external usenet poster
 
Posts: 1
Default formula to a minimum value of zero if a negative number

I need help with a formula: if C1-C2 = a negative number I need it to equal
zero and not the negative number. How do I do this?

It is probably really simple but I cannot wrap my head around it.

Thanks