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".