1 min readfrom 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?

submitted by /u/Professional-Burner1
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article