Using IFs

[Cmorgan]

Afternoon,

I am trying to turn a numerical score into a Y, but with two criterias.

I would like it to check cell AY, and give a Y if

If there is a value in there (not including a formula which gives a blank)
If the value is above 172

If not it needs to give a no.

Thanks

[BadlySpelledBuoy]

=IF(AY1>172,"Y","N")

Change the red 1 to represent the appropriate row number.

[Vikas_Gautam]

Try this..

=if(AY1>172,"Your_Value","")

OR

=if(AND(AY1>172,AY1<>""),"Your_Value","")

[Cmorgan]

Sorry this still isn't working, probably because of my poor explanation. In the cell AY2 there are two possible things:
1. A numerical score (created via a formula)
2. A "blank/empty" cell (created via formula)

I would like the formula to:
- return a Y if AY2 is higher than 172
- return a N if AY2 is lower than 172
- return a blank/empty cell if AY2 is blank

Thanks

[BadlySpelledBuoy]

=if(ay2="","",if(ay2>172,"Y","N"))

[Cmorgan]

Sorted, thanks.