Hi guys
I have 2 cells one in F3 which says #N/A and G3 which is '0' (blank)
My formula in H3 is: =IF(F3=G3, "Aligned", "Not aligned") How can I overcome this to say: If F3 has #N/A and G3 is '0' (blank) return 'Not aligned' because it currently returns #N/A and it's not helpful
thank you.
R.
Bookmarks