Forum Discussion
Solved
Excel formula to apply variable percentages
Hi I need a formula to apply to a cumulative income total which calculate percentages of the total based on its value as follows:- 0 to £5,814 - 0% £5,815 to £23,225 - 100% £23,226 and over - ...
When I'd use the column with % change compare to previous range
with formula
=SUMPRODUCT((B8-$E$2:$E$4)*$G$2:$G$4*(B8>$E$2:$E$4))
Great - thank you. Worked a treat!
Nicola_Ed , you are welcome