ExcelBanter - Excel 97 Calculation Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 97 Calculation Help (https://www.excelbanter.com/excel-discussion-misc-queries/57553-excel-97-calculation-help.html)

JE McGimpsey

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.

Bob

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.

Bob

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.

All times are GMT +1. The time now is 05:35 AM.