Formula help

[sdmccabe]

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?

[Ardus Petus]

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

HTH
--
AP

"sdmccabe" <[email protected]> a écrit dans le message de
news: [email protected]...
> 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?

[KellTainer]

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