Help required with multiple formula

**voniom** · 06-26-2015, 05:29 AM

Hello, would anyone be able to kindly help with a multiple formula?

I would like to calculate a value with a number of results then to be added together for one total.

For example: cell value = 123 and one total calculation to be worked out with the following data:

01-10 x 2.00 = 20.00
11-20 x 1.95 = 19.50
21-30 x 1.90 = 19.00
31-40 x 1.85 = 18.50
41-50 x 1.80 = 18.00
51-60 x 1.75 = 17.50
61-70 x 1.70 = 17.00
71-100 x 1.65 = 49.50
100+ x 1.50 = 34.50

Result would be 213.50

Can this be done? I would be grateful for any tips, thanks :-)

**JohnTopley** · 06-26-2015, 05:48 AM

See attached:

**JohnTopley** · 06-26-2015, 05:49 AM

Sorry ... attached here ....

**Glenn Kennedy** · 06-26-2015, 06:08 AM

The answer you gave for 123 is incorrect. It should have been 213.5 (you multiplied the 71-100 figure by 10, instead of 30). Here's the solution:

**voniom** · 06-26-2015, 06:23 AM

Thank you so much for the tips Guys, I'll give them a go, oh and well spotted with the obvious mistake, it's been a long week! lol thanks again :-)

**JohnTopley** · 06-26-2015, 06:24 AM

I OBVIOUSLY misread the question. See Glenn's result. My apologies.

**voniom** · 06-26-2015, 06:29 AM

Hey, at least you didn't get your OWN calculation wrong! I appreciate your reply to assist anyway, I'm sure I'll need your help again the way this spreadsheet is going!!! thanks ;-)

**Glenn Kennedy** · 06-26-2015, 06:31 AM

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.