Nicole

=IF(SUM(C1:F1)<0,"overage",SUM(C1:F1))


Gord Dibben Excel MVP


On Fri, 4 Feb 2005 11:39:08 -0800, 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?