| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| 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
