| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 47311 | 2004-07-22 13:14:00 | Excel Formula | bk T (215) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 254370 | 2004-07-23 00:52:00 | Should read =IF(OR(ISNUMBER(C1),ISNUMBER(E1)),E1-C1,"") Logic states that if either cell C1 or cell E1 has a number entered then a result will be returned . =IF(AND(ISNUMBER(C1),ISNUMBER(E1)),E1-C1,"") Logic states that only when both cells C1 and E1 have numbers entered then a result will be returned . Cell formating is still optional Many companies would rather lose you as a customer than fix the problem, or even admit that a problem exists - Anonymous |
Merlin (503) | ||
| 254371 | 2004-07-23 01:43:00 | This works fine: =IF(E5="","",E5-C5) Cheers |
bk T (215) | ||
| 1 2 | |||||