# IF statment to verify a number is equal to or between two other numbers

1. ## IF statment to verify a number is equal to or between two other numbers

In cell K3, I need a formula that would verify that cells H3,I3,J3 are all greater than or equal to cell B3 and also less than or equal cell C3, If true a "check" mark would appear in cell K3, if false K3 would be blank.

Thanks  Register To Reply

2. ## Re: IF statment to verify a number is equal to or between two other numbers

Try

=IF(AND(H3>=B3,I3>=B3,J3>=B3,H3<=C3,I3<=C3,J3<=C3),"check",""))  Register To Reply

3. ## Re: IF statment to verify a number is equal to or between two other numbers

Formula:  `Please Login or Register  to view this content.`  Register To Reply

4. ## Re: IF statment to verify a number is equal to or between two other numbers

Sorry I was not clear I am looking to place a "check mark" in the cell not the word check.

Thanks again  Register To Reply

5. ## Re: IF statment to verify a number is equal to or between two other numbers

Instead of check, use P and format the font to wingdings 2.  Register To Reply

6. ## Re: IF statment to verify a number is equal to or between two other numbers

To be more clear

Select K3 cell then change the font to Wingdings 2
=IF(AND(H3>=B3,I3>=B3,J3>=B3,H3<=C3,I3<=C3,J3<=C3),"P",""))  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1