| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenging Charting | Charts and Charting in Excel | |||
| How to insert a complex formula in a cell with VBA | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| Help, insert a word document contents into excel tab? | Excel Discussion (Misc queries) | |||
| insert multiple page Word document into Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
