# 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 structureIn B8 I have a percentageIn 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 appreciatedthanks

See More: Problem with numerous greater/less formula

#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 formula1 - 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

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