•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need more than 3 outputs
Our take
If you're seeking a streamlined approach to implementing conditional outputs in your spreadsheet, consider using an IF OR formula to meet your needs. For your scenario, you can create a formula that checks the value in cell A1 and provides specific responses in cells B1 and B2. If A1 is "A," B1 will display "Yes"; if A1 is "B," B1 will show "No"; and if A1 is "C," B2 will indicate "Maybe.
I’m looking for the cleanest way to add this. Having it feed from another sheet is open to consideration as well.
Basically what I’m looking for is an IF OR formula for 3 conditions and 3 outcomes.
If cell A1 is A the B1 will display as Yes
If Cell A1 is B then B1 will display as No
If cell A1 is C then B2 will display as maybe
Any suggestions?
[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#rows.com#AI formula generation techniques#Excel compatibility#formula generator#Excel alternatives#IF formula#OR formula#Excel#conditions#outcomes#cell A1#conditional logic#cell references#values#formula construction#cell B1#cell B2