About Us

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

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possibly a loaded question, but I think	mileslit	Excel Discussion (Misc queries)	1	September 10th 05 01:18 AM
How do I find and replace a question mark in Excel?	Ranpalandil	Excel Discussion (Misc queries)	1	September 7th 05 10:20 PM
Anybody Help with previous question	Anthony	Excel Discussion (Misc queries)	1	July 26th 05 01:26 PM
Hints And Tips For New Posters In The Excel Newsgroups	Gary Brown	Excel Worksheet Functions	0	April 15th 05 05:47 PM
An easy macro question and one I believe to be a little more diffi	TroutKing	Excel Worksheet Functions	3	January 18th 05 09:17 PM

Menu

About Us