•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Isblank and if combined
Our take
Navigating spreadsheet formulas can be challenging, especially when using functions like ISBLANK and IF together. In your case, the goal is to create a formula that evaluates the content of cells C2 and D2 to provide specific outputs. If C2 is blank, the output should be "prepare strategic plan." If D2 is blank, it should read "prepare for extended research." If neither cell is blank, the output will be "stable." Let's refine your formula to ensure it captures these conditions clearly and effectively.
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
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