Jan 19 2022 12:11 AM
I'm running Windows 10, Excel 2013
In the examples below, I'd like to simply enter the count in C1 and get the result in D5. What would the formulas be in C2, C3, and C4 to break down the number in C1?
Jan 19 2022 12:28 AM
@GeoffT2022 You could use the method demonstrated in the picture below:
Not sure how this will behave in Excel2013. YOu probably need to confirm the formula with ctrl-shift-enter (CSE) which will put curly brackets around it all.
See also attached file.
Jan 19 2022 06:42 AM
Jan 19 2022 06:45 AM
Jan 19 2022 07:20 AM
@GeoffT2022 Then I misunderstood. My thinking was to avoid the row-by-row calculation and come up with a single formula that calculates the total amount payable in one go.
Jan 19 2022 07:29 AM
The question is it acceptable to split Qty column on two with From/To values, or you prefer to work with texts as it is now? The latest bit complicates the formulas which will be harder to maintain.
Jan 19 2022 07:56 AM
@GeoffT2022 Assuming that the boundaries for each group are fixed, you could just use three formulae C2, C3 and C4 as demonstrated in the picture below:
Jan 19 2022 08:27 AM
Jan 19 2022 08:58 AM
Indeed. I forgot about that. Good you figured it out yourself.