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
WalterAPOAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Would not be easier to just show the cumulative difference between what was due and what has been paid?

For C8 use:

=SUM($C6:C6)-SUM($C7:C7)

and then copy right.

Thanks
Rob
0
 
Martin LissOlder than dirtCommented:
I think the formula should just be

=C7-C6
0
 
Martin LissOlder than dirtCommented:
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.
0
All Courses

From novice to tech pro — start learning today.