Excel Conditional statement

Question

i need to write a formula in excel that will perform comparison only if the value is available. i've two columns that will check to see if the amount matches, but could have a blank column, so don't want to perform any comparison when the field is blank. and is there a way that i can hide the formula. example:

jan feb Diff 15900 15880 Not same 10770
9360
7040 7195 Not same 12820 12820 same

Answer 1

Try:

=IF(AND(A2<>"",B2<>""),IF(A2=B2,"Same","Not Same"),"")