Excel Formula problem

Copper Contributor

    A        B           C         D          D - S/B

1 Tom    10.00    5.00     False       5.00

2 Joe      10.00    5.00     False       5.00

3 Mary   10.00    5.00     False       N/A

4 Jan      10.00    5.00     False       N/A

5 Karen  10.00    5.00     False       5.00

The formula in D1 thru D5 =If(A1="Tom",If(A1="Joe",If(A1="Karen",sum(B1-C1),"N/A"))) is returning False and D1-5 should be D - S/B

1 Reply
i think i know your problem. try this formula instead:
=IF(OR(A1="Tom",A1="Joe",A1="Karen"),SUM(B1-C1),"N/A")