?
Solved

If statement and between

Posted on 2011-03-01
3
Medium Priority
?
306 Views
Last Modified: 2012-05-11
Experts, I need to test if D142 is between I18 and J18.  If so, then return 250 otherwise 0.
is this the correct way to write it?  I am not getting the correct answer.
=IF(I18<$D142<J18,250,0)
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 2000 total points
ID: 35012520
=IF(AND($D142>I18,$D142<J18),250,0)

Kevin
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 35012523
=IF(AND(I18<$D142,$D142<J18),250,0)
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 35012531
And because you said "between"

=IF(AND(I18<=$D142,$D142<=J18),250,0)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question