Ignoring blank cells in a formula

[nathp]

Hi All

I have 2 columns in excel with percentage values in each. I have this formula used to return the specified text if either cell is greater than 85%.

=IF(OR(K47>85%,L47>85%),"Urgent (S2)","")

It is working correctly for cells with values in.

My problem is that if the cell is blank it appears to return the text.

Is there a way for this formula to ignore the blank cells?

This one column / formula is part of many others in the sheet so hoping the change can be made in this one formula.

Many thanks

 

[Fluff]

How about

=IF(OR(AND(K47<>"",L47<>""),K47>85%,L47>85%),"Urgent (S2)","")

 

[nathp]

How about

=IF(OR(AND(K47<>"",L47<>""),K47>85%,L47>85%),"Urgent (S2)","")

Still seems to return the text. Not sure if it makes a difference but cells K and L47 (and those entire columns) are a result of another referenced cell.

 

[rlv01]

Maybe this?

=IF(AND(ISNUMBER(K47),ISNUMBER(L47),OR(B1>85%,C1>85%)),"Urgent (S2)","")

 

[Fluff]

Still seems to return the text.

Is that if only one is blank, or both?

 

[nathp]

Maybe this?

=IF(AND(ISNUMBER(K47),ISNUMBER(L47),OR(B1>85%,C1>85%)),"Urgent (S2)","")

That seems to have done it thank you

 

[nathp]

Is that if only one is blank, or both?

That was if both were blank but I think I have the solution below now, thank you

 

[Fluff]

So do you want a blank cell if either are blank?