Formula for Petty Cash form to return -/+ amount?
Assuming the three numbers from your example occupy cells B2 to B4,
enter this formula in B5:
=B3+B4-B2
This will give a negative value if the cash spent plus cash remaining
are less than the float.
Hope this helps.
Pete
|