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?
|