Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula
Hi
I have a formula that goes like this: =IF(C10B10,C10-B10,"€¦"). In cells C and B there are times, however. they put in "Not Running" in cell "C" and therefore I get a return error of #Value. How can Ii change my formula to calculate the difference in cells C and B but leave the cell empty if cell C has "Not Running" in it. Thanks -- All help much appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |