Hi!
I'm working on a formula for eligibility (insurance). Essentially I have a massive sheet showing eligibility by benefit (A1 would be Medical Insurance, A2 would be either Eligible or Not Eligible, for example).
I was attempting to make an IF statement that would bring every eligible benefit into one cell, but I'm not entire sure this is the right approach. Cells M2:AR2 are various benefits, each with either that "Eligible" or "Not Eligible" indicator.
Without listing the entire formula, which didn't exactly get the job done, my format was this:
=IF(M2="Eligible","Medical Eligible"&IF(N2="Eligible",", Med2 Eligible"&IF(O2="Eligible",", MedPPO Eligible"&IF(P2="Eligible",", MedPPO PHARM Eligible"&IF(Q2="Eligible",", MedPPO VAC Eligible"&IF(R2="Eligible",", Gap Eligible","Not Eligible"))))))
The formula brings over just one benefit rather than each eligible.
I'm ultimately attempting to create a cell that shows "Medical Eligible, Gap Eligible, Disability Eligible," etc dependent on cells M2:AR2.
Bookmarks