vendredi 11 septembre 2020

Excel IF AND OR statement syntax issue

I’m hoping someone can help me with getting the correct syntax for this formula.

=if(and(panel_quantity>0),OR(c1:z1)<>””),”yes”,”no”)

Below is an explanation For what I want the formula to achieve.

If Panel_Quantity is greater than zero AND if and any of the cells in the range of C1:Z1 contains any text/value/formula then cell value is “yes”, otherwise “no”.

Thanks.

Aucun commentaire:

Enregistrer un commentaire