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 parametersEG

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

I assume B8 is the result of a formula. 2 things are missing from your question:

1 - What if B8

equals79.99% or 99.99%, etc? You used the wordbetween, but not the wordsequal 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.

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 etcany pointers on how to build this formula would be greatly appreciated

Thanks for your help DerbyDad03 - I've managed to research and find a formula that works! cheers

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History