NESTED IF formula

Melanie Sanders

Hello again, I tried to ask this in my last thread of another question with similar columns but realized I should just create a new question.

I have a column titled LICENSE TYPE that I would like to populate if there is text in one of the above 4 columns with the text in that column. Each row will only have 1 of the 4 columns populated. Can you assist with this formula as well? In rows 1-3 the LICENSE TYPE column should contain Pharmacy-nonresident and rows 4-5 would have Sterile Compounding while 6-10 would have Manufacturer, etc.

Thank you!

Melanie Sanders

Thank you! Worked like a charm.

Louis1

Hi M,

I did this that may provide what you want - the formula column (also set as acolumn formula) is

=IF([Licence Type A]@row <> "", [Licence Type A]@row , IF([Licence Type B]@row <> "", [Licence Type B]@row , IF([Licence Type C]@row <> "", [Licence Type C]@row , [Licence Type D]@row )))

Just replace A, B, C and D in the formula with your headings

Melanie Sanders

Thank you! Worked like a charm.