Another IF question

P

piglett51

This is probably really easy and I am just blanking on it. Looking for
help?

IF(M2="38000:39000", "p2", "")

So I am trying to populate a field only IF M2 is between 38000-39000.

Thanks!
 
S

Sandy Mann

Try:

=IF(AND(M2>=38000,M2<=39000), "p2", "")

If you don't want p2 in response to M2 being actually 38000 or 39000 then
miss out the "=" in both tests.

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top