Calculate One Value Based on a Formula for Three Other Values

Any thoughts on how to do this?

Cell A, B & C all have a value in them. Based on those values, a new value is calculated for each one based on this…

<0.1%: +0
0.1% to 2.5% +1
2.6% to 5.0%: +2
5.1% to 10.0%: +3
10.1% to 15.0%: +4
15.1% to 20.0%: +5
20.1% to 28.0%: +6
>28.0% +7

…and then the three new values are added together with the result showing up in Cell D. So, the max value possible for Cell D is 21.

BTW, I'm using Microsoft 2008 for Mac for this particular project if that makes any difference.

Hi,

See attached

Id use a user defined function.

This seems tp work but is a bit crude

Please Login or Register  to view this content.