Problem with numerous greater/less formula

September 12, 2011 at 01:24:05
Specs: Macintosh
I'm having issues working out how to build this formula to represent a bonus structure

In B8 I have a percentage
In C8 I wish to show a number relating to that percentage which has numerous parameters

EG
If B8 is between 0% to 79.99% the value in C8 should show 0%
If B8 is between 80% to 99.99% the value in C8 should show 1%
If B8 is between 100% to 119.99% the value in C8 should show 2%
If B8 is equal to or greater than 120% the value in C8 should show 3%

I'm not very experienced with complex formulas so any help would be massively appreciated

thanks


See More: Problem with numerous greater/less formula

Report •


#1
September 12, 2011 at 08:08:02
I assume B8 is the result of a formula.

2 things are missing from your question:

1 - What if B8 equals 79.99% or 99.99%, etc? You used the word between, but not the words equal to.

2 - What happens if it evaluates to 99.991% or 119.995?

Your criteria needs to be more specific.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 12, 2011 at 16:03:33
Thanks for your input, to fill in those blanks....

Yes B8 is the result of a formula

1 - where I have put 'between' I meant 'equal to or between'
2 - the percentages are only calculated to 2 decimal places. They would be either rounded up or down to result in a maximum of 2 decimal places. 99.991 would become 99.99 etc etc

any pointers on how to build this formula would be greatly appreciated


Report •

#3
September 12, 2011 at 19:01:15
Thanks for your help DerbyDad03 - I've managed to research and find a formula that works!

cheers


Report •
Related Solutions


Ask Question