Forum Discussion
Need right formula for multiple IFS
Hi, I want to create the following logic with the below table: a. If Prep start month and year is more than Current month (Col. H - Dec'20), then 0 b. If a is false, then only check Responsible...
Hello Nishantu309034,
Starting in cell H38, that could be:
=IFS(D38-$H$37>0,0,E38="CEO",0,E38="Product Manager",1)
Worked like a charm, thanks