ineed this formula but it is not working

June 16, 2011 at 02:36:47
Specs: Windows XP
=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%)))))))))))))))

See More: ineed this formula but it is not working

Report •


#1
June 16, 2011 at 05:33:38
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.


Report •
Related Solutions


Ask Question