Formula
No.
--
David Biddulph
"Donna" wrote in message
...
Thanks. If a1 and b2 are formulas would I need to copy and paste the
values
into new columns?
"Kevin B" wrote:
If the return values are numeric use this function:
=IF(A1=B2,7641,7642)
Otherwise, use this function:
=IF(A1=B2,"7641","7642")
--
Kevin Backmann
"Donna" wrote:
What is the formula for:
if data in a1 is the same as data in b2 then "7641" otherwise "7642"
|