ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   If Statement Between Ranges? (https://www.excelbanter.com/excel-discussion-misc-queries/14590-re-if-statement-between-ranges.html)

Geeoff

If Statement Between Ranges?
 
Greg, that is such a good help. i was looking for the same answer. Thanks
for stepping up and helping me out, just as much as the person who made the
original post.

"Greg" wrote:

=IF(AND(A1=26, A1<=74),"TRUE","FALSE")




MJSlattery wrote:


I am looking for one statement that give me a "TRUE" when the IF
statement is between two values?

I will be able to utilize your answere to this problem in other
situations but not here.

Thanks,

Michael


--
Greg
phobos78-marslink-net
Replace dashes and move in by 1 planet to reply.



All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com