Help with If statment to compare values

V

Vika

Thank you to all of you for your help. I tried each provided option and
they all work great!!!

Many, many thanks!!!! Super!!!....

Vika
 
M

Max

As you're posting / reading from Excelbanter.com, you should be aware that
Excelbanter's interface seems to remove all traces of "greater than" or
"less than" operator symbols, including those within posted formulas.

For example, for the formula suggested in my response,
the .. IF( OR( A1 "less than" zero, A1 "greater than" 55 ) , .. error trap
part appears erroneous as: .. IF(OR(A10,A155), .. in Excelbanter

In case you might want to see it as it was posted,
try: http://tinyurl.com/a4zpp
 
Top