Nicole L. wrote...
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?
If you just want negative numbers to display differently, use a custom
number format. Format Cells, Number tab, select Custom from the
Category list, then in the type field enter
#,##0;-#,##0" overage";0;@
|