If/then statements in multiple cells

[Fredilev]

I'm trying to figure out how to write a formula for the following:
I have data in cells d12, d13 and d14. If the number in each of those cells is 6.5 or higher then I need the words "Meets Criteria" to appear in cell d11; if the number is lower than 6.5 in any of those cells then the words "Does Not Meet Criteria" needs to appear in D11.

I've been trying to figure out how to do this with IF and AND statements but I can't get it to work.

Thanks.

 

[VoG]

Try

=IF(AND(D12>=6.5,D13>=6.5,D14>=6.5),"Meets Criteria","Does Not Meet Criteria")

 

[JackDanIce]

Welcome to the board.

Try:

=IF(AND(D12>=6.5,D13>=6.5,D14>=6.5),"Meets Criteria","Does Not Meet Critera")

 

[njimack]

Providing the cells will always contain a number (either greater than or less than 6.5):
=IF(COUNTIF(D12:D14,"<6.5"),"Does not meet criteria","Meets criteria")

If the cells could also be blank or contain text, post back and I'll revise the above

 

[Fredilev]

Thank you so much!!! This is great!!

 

[Maheshp]

Try :
=IF(AND((D12>=6.5),(D13>=6.5),(D14>=6.5)),"Meets Criteria","Does Not Meet Criteria")

 

[Fredilev]

One more question on this. If the cells are merged (D13/E13/F13); could that cause a problem with the formula working?

 

[VoG]

I think it should still work but setting horizontal alignment to Center Across Selection is an alternative to merging.