# 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

#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