I am creating a uniform allowance spreadsheet to make tracking employee purchases simple.
Data
Allowance: 150
This is the amount of money the employee is entitled to for uniforms
Price:
This is the actual price of the uniform
Employee Cost:
This is the amount billed to the employee. They are billed anything over $150.
My problem is how to set up the formula for Employee Cost. I have Allowance in A6, Total Amount Purchased in G25, Price in G3-G23 and Emplyee Cost in H3-H23.
Thanks so much in advance ... this has had me stumped for awhile!
Bookmarks