1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Isblank and if combined

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.

submitted by /u/FIV626
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#rows.com
#financial modeling with spreadsheets
#isblank
#if
#formula
#prepare strategic plan
#prepare for extended research
#stable
#c2
#d2
#error
#output
#blank