What is the formula for: if data in a1 is the same as data in b2 then "7641" otherwise "7642"
D Donna Jan 22, 2009 #1 What is the formula for: if data in a1 is the same as data in b2 then "7641" otherwise "7642"
K Kevin B Jan 22, 2009 #2 If the return values are numeric use this function: =IF(A1=B2,7641,7642) Otherwise, use this function: =IF(A1=B2,"7641","7642")
If the return values are numeric use this function: =IF(A1=B2,7641,7642) Otherwise, use this function: =IF(A1=B2,"7641","7642")
D Donna Jan 22, 2009 #3 Thanks. If a1 and b2 are formulas would I need to copy and paste the values into new columns?
D David Biddulph Jan 22, 2009 #4 No. -- David Biddulph Donna said: Thanks. If a1 and b2 are formulas would I need to copy and paste the values into new columns? Click to expand...
No. -- David Biddulph Donna said: Thanks. If a1 and b2 are formulas would I need to copy and paste the values into new columns? Click to expand...
