•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can you do an if function (or any other) that prints multiple things?
I'm doing a lease audit at work that has multiple columns for Y/N questions and a final notes column that we put specific notes in according to the Y/N answers. I know how to use if statements to print 1 answer in a cell but is it possible to nest statements so that it will insert different notes automatically as I answer the Y/N questions?
For a clearer picture, the Y/N questions are asking if we have an ID, a signed lease, and if they have insurance. If they have them I need the formula to look for a ”Y" or "N" in 3 separate cells and give notes to say "ID/No ID, Lease/No Lease on file, Insured/Unisured" in a single cell all depending on the Y/N it looks for.
Is this possible to do?
[link] [comments]
Want to read more?
Check out the full article on the original site
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
#if function
#Y/N questions
#nested statements
#lease audit
#formula
#ID
#signed lease
#insurance
#notes column
#cells
#Excel
#output
#automatically
#conditional logic