View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
casst casst is offline
external usenet poster
 
Posts: 2
Default Help Needed ASAP

I need to subtract one cell from another cell. However, I don't want to see
any negative numbers, instead I only want a zero. For example:

If A2 is 300 and B2 is 150 than C2 should be 150
If A3 is 150 and B3 is 300 than C3 should be 0 (not -150)

Is this possible, and if so, how do I write the formula.

Thanks