Another IF question

  • Thread starter Thread starter piglett51
  • Start date Start date
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!
 
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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Quetion about lookups with errors 4
Excel Moving data from one line to another 0
Help with a really big IF statement 9
Average for a column to exclude zeros and numbers above 39000 3
IF-Then formula problem 6
Requiring multiple cells to be populated before allowing Save 2
Need a function to fill column from other columns 5
How do I stop Excel from treating blank cells as zero? 2

Back
Top