if or and empty cells

[Rodrigues]

all
I'm looking for a formula with multiple if/or statements, let's say:

Formula need on Cell CC4

Conditions:
if(BX4="",""
if(BY4="", check if there is a value on CB4 if yes =IF(CB4>10,"Hello", if not ""
if(CB4="", check if there is a value on BY4 if yes =IF(BY4>0),"Hello", if not ""


Have a formula on file attached,
=IF(BX4="","",IF(BY4="","",IF(CB4="","",IF(OR(BY4>0,CB4>10),"Hello",""))))
however is not doing what I need, as per example on cell CC6, should return Hello.
Thanks in advance
regards
R

 

[bosco_yip]

Maybe,

=IF(BX4="","",IF((BY4="")*(CB4>10)+(BY4>0)*(CB4=""),"Hello",""))

Regards

 

[Rodrigues]

Bosco
Apologies forgot to thank you.
That does work very well.
Thanks again.
Regards
R