ExcelBanter - Another IF question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Another IF question (https://www.excelbanter.com/excel-worksheet-functions/45661-another-if-question.html)

piglett51

Another IF question

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!

--
piglett51
------------------------------------------------------------------------
piglett51's Profile: http://www.excelforum.com/member.php...o&userid=27291
View this thread: http://www.excelforum.com/showthread...hreadid=468034

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

Replace@mailinator with @tiscali.co.uk

"piglett51" wrote
in message ...

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!

--
piglett51
------------------------------------------------------------------------
piglett51's Profile:
http://www.excelforum.com/member.php...o&userid=27291
View this thread: http://www.excelforum.com/showthread...hreadid=468034

All times are GMT +1. The time now is 05:37 PM.