lundi 3 juillet 2017

writing an if, elseif; block in excel

Ive got the following statement in excel :

=IF(OR(L744=0, N744>0), "price ?", "")

I want to update it to be :

IF(OR(L744=0, N744>0), "price ?", "") ELSEIF(NOT(ISBLANK(P744), "")

But it seems excel dosnt have an ELSEIF block. Any ideas whats the most semantic way of writing this in excel ?

Aucun commentaire:

Enregistrer un commentaire