View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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