Help creating 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!!
 
dmeals

Can you describe the layout of the sheet and maybe some sample data? I'm
having trouble trying to visualize what's going on. Also, provide what
you've tried, even if it doesn't work.
 

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 what should be easy formula! 1
Create a new function... 8
formula help 4
Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting 1
I need to look for a number and return the column heading. 6
Complex IF formula 4
Need Help with formula 2
Formula problem 2

Back
Top