=IF(C19<=500,OR(J19<=27)*15%,IF(C19<=3000,OR(J19<=27)*13%,IF(C19<=10000,OR(J19<=27)*11%,IF(C19<=20000,OR(J19<=27)*9%,IF(C19<=500000,OR(J19<=27)*7%,IF(C19<=500,OR(J19<=15)*10%,IF(C19<=3000,OR(J19<=15)*8%,IF(C19<=10000,OR(J19<=15)*6%,IF(C19<=20000,OR(J19<=15)*4%,IF(C19<=500000,OR(J19<=15)*2%,IF(C19<=500,OR(J19<=200)*20%,IF(C19<=3000,OR(J19<=200)*18%,IF(C19<=10000,OR(J19<=200)*16%,IF(C19<=20000,OR(J19<=200)*14%,IF(C19<=500000,OR(J19<=200)*12%)))))))))))))))

I'm not going to try and decipher what you are trying to do, so I'll just toss this out: The OR function is used to compare 2 or more values. Your use of OR with a single argument makes no sense since it is not comparing anything.

OR(J19<=27)

A typical IF(OR...)) function would look like this:

=IF(OR(A1=2,B1=3),

value_if_true, value_if_false)which would be TRUE if either A1=2 or B1=3 or both A1=2 and B1=3.

In addition, I don't know what you are trying to do when you use this syntax:

(J19<=27)*15%

The parenthesis don't make sense to me.

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

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History