Here,Type this in A3:what formula would look like to perform something like that
if a2=a1 then in a3 print nothing
I should be asking him this question?What if B1 <> A1?
ADVERTISEMENT
or FALSE? (assuming all the adjustments are made to ZAX formula & its locatiomn to refer to the cells the OP mentioned )Your answer will return "TRUE" if A1 <> B1
ADVERTISEMENT
=IF(B1=A1,"",B1)