Excel 2010
I have a simple spreadsheet that I can’t figure out. This is an office fund sheet. If the employee contributes more or less than the Per Person Charge, I can’t get the correct results. If employee 1 pay $40 the formula in cell C8 works, but if employee 1 pay $20 the formula is wrong. Paying $20 C8 should be a negative or red 5, but it positive 5. I think I got the formula for D6 to work. Please help.
Thank you,
Walter
Office-Fund.xlsx
Thank you,
Walter
Office-Fund.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've requested that this question be closed as follows:
Accepted answer: 250 points for Martin Liss's comment #a40607035
Assisted answer: 250 points for Rob Henson's comment #a40607575
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 250 points for Martin Liss's comment #a40607035
Assisted answer: 250 points for Rob Henson's comment #a40607575
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
=C7-C6