Return target cell if its' answer is true.

[Kevin M]

Hi everyone, experimenting with an AND formula and i'm
looking for some guidance.

Columns L, N, O, and P that contain the data, if one or
more of them are empty, i'd like the formula to return
which one(s) are empty as my answer in Col Q.

That's about all the info..
TIA
Kevin M.

 

[Ken Wright]

In any cell on row 1

=IF(L1="","L","")&IF(N1="","N","")&IF(O1="","O","")&IF(P1="","P","")

and copy down. Havent included Row number as that should be obvious from the
location of the formula

 

[Kevin M]

Thanks Ken, i guess a few more minutes of thinking would
have saved me wasting your time.

Kevin