HELP creating what should be easy formula!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dummy here.

- Paying a worker 200 non-recoverable draw, weekly
- Paying same worker 250 recoverable draw, weekly
- Combined draws = gauranteed 450 weekly income

Trying to create a formula to accomplish the following.

- If billed hours generates income below 450, I pay the gaurantee and carry
forward the amount greater than the 200 non-recoverable.
- If billed hours generates income above 450, I want to deduct an amount of
accrued recoverable draw, but not to exceed the 450 weekly gaurantee - THIS
IS THE TOUGH PART FOR ME!

Any help appreciated!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating formula 1
Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting 1
Need Help with formula 2
Formula help in a monthly sales report. 4
Need help with Overtime formula. 6
Formula, Pivot Table, ??? Beats me 2
Help with IF formula 2
Formula problem 2

Back
Top