hi guys
im trying to do the following
if a1 has "clear" and b1 has "clear" and c1 has "dark"
in d1 i would like the answer clear/clear/dark
however
if there is nothing in c1
i would like the return to be clear/clear
how can i do this please?
thanks in advance
Bookmarks