| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HELP creating what should be easy formula!
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!! |
|
#2
|
|||
|
|||
|
SORRY FOR THE DOUBLE POST!!
"dmeals" wrote: 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
| HELP creating formula! | Excel Worksheet Functions | |||
| Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
| I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
Linear Mode
