IF statements referencing an absolute value or a range of valu
Thanks to both John and Ron for your quick responses! Both solutions worked
for me. Your help was much appreciated.
"John Bundy" wrote:
If it is cell A1
=IF(A1=-5,IF(A1<=5,"Ok","Validation Error"),"Validation Error")
to make it a static reference add $'s
=IF($A$1=-5,IF($A$1<=5,"Ok","Validation Error"),"Validation Error")
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.
"skaminski" wrote:
Does anyone know how to create a conditional statement for the following
situation?
If the value in a particular cell is between -5 and 5, then return a message
that says "ok", otherwise return a message that says "validation error".
|