| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allocated amount rounded to nearest .25 without exceeding total
I'd like to be able to allocate an amount to the nearest .25 without
exceeding the total being allocated. How do I do this? I'm working with hours and allocating overtime between projects. example: Project 1 hours = 40 Project 2 hours = 8 OT is 5.25. I need to allocate the 5.25 to each of the projects based on their ratio without exceeding 5.25. Currently using ROUND((C5*F6)/0.25,0)*0.25 where c5 is the OT (5.25) and F6 is % of project time to total time (ex. 40/48). The results are Project 1= 4.5 and Project 2 = 1 but this exceeds the total of 5.25. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show fractions rounded up to nearest 1/16th inch | Excel Discussion (Misc queries) | |||
| subtract entries from allocated total until it reaches zero | Excel Worksheet Functions | |||
| Ensuring input is rounded up to nearest 10 | Excel Discussion (Misc queries) | |||
| How do I get a calculated amount to round to the nearest nickel? | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Threaded Mode
