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 |
#2
|
|||
|
|||
Hi!
Can't tell what you have as Value_IF_False argument? =3DIF(C10B10,C10-B10,"=E2?=A6") Try this and replace XXX as needed: =3DIF(ISTEXT(C10),"",IF(C10B10,C10-B10,"XXX")) Biff -----Original Message----- Hi=20 I have a formula that goes like this: =3DIF(C10B10,C10- B10,"=E2?=A6"). In cells C and B there are times, however. they put=20 in "Not Running" in cell=20 "C" and therefore I get a return error of #Value. How can Ii change my formula to calculate the difference=20 in cells C and B=20 but leave the cell empty if cell C has "Not Running" in=20 it. Thanks=20 --=20 All help much appreciated. Thanks . |
Reply |
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 |