▲ 1 r/excel
Heyyy!
Stress with this one should be simple but it is giving me error.
Basically the formula was "if(and(isblank(c2),"prepare strategic plan"),if(and(isblank(d2),"prepare for extended research","stable")
Should be output.
If the c2 is blank the returned will be "prepare strategic plan"
If d2 is blank "prepare for extended research"
If the c2 and d2 is have both the returned should be "stable"
This is simple formula but I can't figured out. Been researching to other excel guide websites. I can't find the right one
Thank you for the help : ) please guide me to understand on how anf why I was wrong.
u/FIV626 — 16 days ago