mercredi 5 juillet 2017

excel - nested if condition formatting

I was just wondering if this is the proper way to nest this many conditions. It does work, just looks like it could be written simpler.

=IF(H13>0,IF(H14>0,IF(H15>0,IF(H16>0,IF(H17>0,IF(H18>0,IF(H19>0,"Yes","No"),"No"),"No"),"No"),"No"),"No"),"No")

Aucun commentaire:

Enregistrer un commentaire