Nov 09 2021 06:53 AM
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
Nov 24 2021 05:43 PM