View Single Post
  #1   Report Post  
Nicole L.
 
Posts: n/a
Default if formula = negative #, then insert a word

I have a cell (G1) that is the sum or some other calculation of other cells
(SUM(C1:F1))...
What formula do I use to say that IF that calculation turns out to be a
negative, I'd like a word added, such as "overage" or something?