As an example

=IF(A1<1000,-1,IF(A11000,1,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ufo_pilot" wrote in message
...
Hi, I'm new here, hope you can help.
I am struggling with trying to test if a value is between two others with
the IF statement
A value between two others would be TRUE, so
If TRUE then 0
if FALSE then test if it larger or smaller
If smaller then -1
If larger then +1

I can't seem to get the whole thing off the ground, keep going in circles
Please help, getting dizzy

Thanks