Hello Forum Users,
I have a little problem I have an issue with.
I have a workbook that is supposed to do the following:
1) Creates a benefit based on quote/percentage (C4:C15*P4:P12) or smallest limit remaining (H23:H90) Code A-I
2) Creates a benefit based on quote/scheduled benefit (C4:C15*H4:H15) or smallest limit remaining (H23:H90) Code J-O
4) Creates a benefit based on quote/percentage, maximum $98.00 amount (per item) (C4:C15*P8 or C4:C15*Q8 (whichever is less) or limits remaining (H23:H90) Code E
I am having trouble getting the balance of the benefits in the column to calculate correctly
e.g I4:I15 at the moment has $20.00 left in remaining benefits (as that's the smallest amount between the percentage & limits remaining, however you can see row I4 is showing a full benefit of $112.50 when in actual fact should calculate as $20.00 (H25), the next line (I5) should be $0.00 as there would be no benefits left to pay
Item 4 I have not been able to work out how to make it calculate correctly either 75% of the quote column "G" or $98.00 per 1 quantity (whichever is less)
Lastly, I would like to be able to have a user entry form (a box) in O2, which I can enter the totals into for the range H23:H90 & they fill into the appropriate cells down the page automatically (without having to scroll down to the rows myself to enter the data
Any help would be appreciated
Bookmarks