Formula 'stops' part way through?

Originally Posted by lock-e73

Hi all,

Bit of a newbie to the whole Excel programming thing so any help very much appreciated on this small matter

I have developed (at least I thought I had!) a formula which will give me x% depending on certain < = > values. See below:

=IF(A10<=499,15%,IF(OR(A10>500,A10<999),10%,IF(OR(A10>1000,A10<2499),8%,IF(OR(A10>2500,A10<5000),7%,5%))))

Excel accepts the formula but won't give me any % lower than 10%. I was wondering if any of you gurus could point out where I've gone wrong?

Once again ... any help much appreciated!

Lock-e73

Hi,

try something like

=IF(A10<500,15%,IF(A10<1000,10%,IF(A10<2500,8%,IF(A10<5000,7%,5%))))

hth
---

Originally Posted by lock-e73

Hi Bryan,

Thanks for your quick response. Looks like I've over done it a bit. Thought I'd need all the OR statements to lock it into the particular ranges, but forgot that Excel works 'through' a formula only moving to the next step if the previous is not met.

Thanks heaps ... saved my bacon!

Lock-e73

yes, you also missed the =1000 bit (and =999 etc) which would then get 5%, but, good to see it's resolved, and thanks for the response.

---