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
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
Last edited by timothyg; 11-03-2012 at 07:49 AM.
Try
=IF(AND(H3>=B3,I3>=B3,J3>=B3,H3<=C3,I3<=C3,J3<=C3),"check",""))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Formula:Please Login or Register to view this content.
Sorry I was not clear I am looking to place a "check mark" in the cell not the word check.
Thanks again
Instead of check, use P and format the font to wingdings 2.
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",""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks