attach'd shows scenario -- Col E would hold formula/function -- IF D2 holds #N/A (General formatting) then place contents from C2 into E2
If not, then keep cell blank as image shows (or if easier, a zero result is fine)
Thanks!
bring-over-adjacent-if-na.GIF
Bookmarks