Re: Combine if statement with 3 different return
Quote from S O;771565The formula is tested and worked fine, it must be the data. Of course, that can't be confirmed without seeing an example.
[sw]*[/sw]
Attached is the file.
Posts by str1k3r
-
-
Re: Combine if statement with 3 different return
Quote from S O;771542This should do what you need:
=IF(OR(C5="",I5=""),"",IF(I5="F",7,SWITCH(WEEKDAY(C5),7,6,1,6,5)))
The result return with "#NAME?"