PCA Forums

Hello all. I've been lurking for some time, but need to post because I am stumped here. My copy of MS Excel 2000 seems to think that 20>150 is TRUE. I have a screen shot, because I'm sure some of you are laughing at this point (93k, watch out modems):

<a href="http://www.geocities.com/stevetruckstuf ... .JPG">F-ed up Excel</a>

You will notice that cell Q5 evaluates to "Yes." However if you look at the formula in the formula bar, all of the conditions should be false, making cell Q5 evaluate to "No." But it obviously doesn't. Now the kicker. Cell Q2 contains the formula "=J14" (you'll have to take my word for it) which evaluates correctly to 20. Cell R2 contains the equation"=J14>150" and it STILL evaluates to TRUE. After playing around, I have found that every time I use the '>' operator with a cell and a value (i.e. J14>any number) it evaluates to TRUE and if I use a '<' operator it evaluates to FALSE. But if I use the real numbers (i.e. 20>150) it evaluates correctly. So what in the world is going on here?? Can someone see where I am making a stupid mistake? Anyone have a tech support email/number for MS? Any help is appreciated.

Thanks.

You need to a logical test, such as "IF". Do a help search for the function "IF" in Excel help. Here is what is displayed: (IF logical_test,value_if_true,value_if false).

Hmmm.... I am doing a logical test right now. The OR is inside an IF function. This same function has worked fro me dozens of times before, so I'm not sure what is wrong here.