|This is not the correct syntax for checking 2 conditions:|
You have to check each condition by itself and logically AND them:
BTW, what if the value is exactly 30000 or 90000?
You should account for that by using operators such as >= and <=.
In your case (even though the syntax is wrong) you are using the same values twice for different conditions:
Once you get the syntax correct, you will find that Excel is going to stop at the first TRUE condition and ignore everything after it. Excel does not check every condition and then decide which one is "more TRUE". It stops and retuns a value as soon as it finds a TRUE condition as it evaluates the formula from left to right.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.