Cash verification

[Arthur]

I have created a batch summary verification sheet for
balancing payments received in a payment center. I have
one cell for cash totals (cash on hand) and one cell for
system cash totals (cash I should have) I have created two
additional cells for cash overage and shortage. How would
I create a formula to show a negative amount in the cash
shortage and a positive amount in the cash overage cells?
Thank you for your assistance.

 

[JulieD]

Hi Arthur
assuming your data is laid out as follows

A B C D
1 Cash Totals System Cash Totals Overage Shortage
2 10 20 =A2-B2 =B2-A2

Hope this helps
Cheers
julieD

 

[Arthur]

Julie,
Thank you for your input. I tried your formula but I
belive this needs a more involved formula.

Regards,
Arthur

Cash on hand below:
1 x $100.00 $100.00
1 x $50.00 $50.00
1 x $20.00 $20.00
x $10.00
1 x $5.00 $5.00
x $1.00
x $0.50
x $0.25
x $0.10
x $0.05
x $0.01

TOTAL CASH (ADD ALL ABOVE) $175.00
TOTAL CHECKS
TOTAL CASH (MINUS $75 Cash Drawer) $100.00 (D28)

System receipts below:
CASH RECEIPTS $90.00 (D30)
CHECK RECEIPTS
TOTAL RECEIPTS $90.00 (D32)

CASH SHORTAGE -$10.00 (D34) Needs to be red negative.
CASH OVERAGE ? (D35)

Both the cash shortage and overage need to remain blank or
show zero if nothing is found. This information carries
over to another sheet and will create errors if numbers
are not shown correctly.

-----Original Message-----
Hi Arthur
assuming your data is laid out as follows

A B C D
1 Cash Totals System Cash Totals Overage Shortage
2 10 20 =A2- B2 =B2-A2

Hope this helps
Cheers
julieD

two additional cells for cash overage and shortage. How
would I create a formula to show a negative amount in the
cash shortage and a positive amount in the cash overage
cells?

 

[JulieD]

Hi Arthur

okay, try this then
in D34
=IF(D32>D28,D28-D32,0)

in D35
=IF(D32<D28,D28-D32,0)

format as necessary

Cheers
JulieD

 

[Arthur]

Julie,
I love you! My workbook is perfect because of you.
Thank you very much. If you need a favour and I could
assist please contact me. Be well.

Regards,
Arthur

 

[JulieD]

Hi Arthur

<vbg> thanks for the feedback.

Cheers
JulieD