Show cell value IF/

[jmazorra]

Hello folks:

On cell A11 I have the following formula:

=IFERROR(LARGE(ttestmalecalc!$D:$D,10),"")

I need to modify the formula so that if B11 does not have a value, then A11 does not return a value either.

 

[Scott Huish]

If you need B11 to be a number:
=IF(ISNUMBER(B11),IFERROR(LARGE(ttestmalecalc!$D:$D,10),""),"")

if anything:
=IF(B11="","",IFERROR(LARGE(ttestmalecalc!$D:$D,10),""))

 

[jmazorra]

Thank you for the quick reply