Can anyone please help with the following problem?
I want to set up an IF function such that if a value falls within +1 and -1 the result is "OK", if not the result is "ERROR".
Cannot seem to get this correct.
Many thanks
Can anyone please help with the following problem?
I want to set up an IF function such that if a value falls within +1 and -1 the result is "OK", if not the result is "ERROR".
Cannot seem to get this correct.
Many thanks
Hi
Try this:
=IF(AND(A1>-1,A1<1),"OK","ERROR")
Click *, if my suggestion helps you. Have a good day!!
Thank you - that has helped enormousley!
You r welcome ....
Or
=IF(ABS(A1<1),"OK","ERROR")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks