Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prorate amount
How can I prorate 2727.29 based on these original amounts?
A B C D E Totals 1 1531.19 153.11 20.00 298.58 15.00 2017.88 2 6.60 .66 1.29 8.55 3 20.00 2.00 3.90 25.90 4 2.77 .27 . 54 3.58 5 211.08 21.10 41.16 273.34 6 3.47 .34 . 68 4.49 7 13.00 1 .30 2.54 16.84 8 27.60 2.76 5.38 35.74 9 566.27 56.62 110.42 733.31 10 171.75 17.17 20.00 33.49 242.41 Totals 2553.73 255.33 40.00 497.98 15.00 3362.04 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the amount of time over a permitted amount (12 hours) | Excel Discussion (Misc queries) | |||
prorate formula | Excel Worksheet Functions | |||
Printing a certain amount of pages based on amount of data | Excel Programming | |||
Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions |