Formula help
 

Will you suggest a formula to compare the values of two different cells and,
if the values are equal, input a character (as asterisk) in the formula cell?

Formula help
 

=IF(A1=A2,"*","")

HTH
--
AP

"sdmccabe" a écrit dans le message de
news: ...
Will you suggest a formula to compare the values of two different cells
and,
if the values are equal, input a character (as asterisk) in the formula
cell?

Formula help
 

=if(a1=b1,"*","")


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=548298