View Single Post
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default How do I find and replace a number with a minus sign in front?

Hi

We need a bit more information to help.
Are you wanting to return a 0 rather than a negative result from a
calculation?
=MAX(0,A1-B1)

--
Regards

Roger Govier


"D.Sommer" wrote in message
...