| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 97 Calculation Help
One way:
D11: =IF(AND(C11=0,B11=0),0,C11-B11-14) E11 takes care of itself - if C11=0 and B11=0, then D11=0, and C11-B11-D11 = 0. In article , Bob wrote: Using Excel 97. Trying to take "=(C11-B11)-14" into field D11. However, if C11 and B11 = 0, then I want a 0 in cell D11. Also,trying to take "=(C11-B11)-D11" into field E11. However, if C11 and B11 = 0, then I want a 0 in cell E11. Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 97 Calculation Help
Using Excel 97. Trying to take "=(C11-B11)-14" into field D11. However, if
C11 and B11 = 0, then I want a 0 in cell D11. Also,trying to take "=(C11-B11)-D11" into field E11. However, if C11 and B11 = 0, then I want a 0 in cell E11. Please help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 97 Calculation Help
Thank you, Thank you, Thank you.
"JE McGimpsey" wrote: One way: D11: =IF(AND(C11=0,B11=0),0,C11-B11-14) E11 takes care of itself - if C11=0 and B11=0, then D11=0, and C11-B11-D11 = 0. In article , Bob wrote: Using Excel 97. Trying to take "=(C11-B11)-14" into field D11. However, if C11 and B11 = 0, then I want a 0 in cell D11. Also,trying to take "=(C11-B11)-D11" into field E11. However, if C11 and B11 = 0, then I want a 0 in cell E11. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| EXCEL: FLOOR/SPACE RATIO CALCULATION | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Amortization Calculation in Excel worksheet | Excel Worksheet Functions | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
