| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
What is the formula for:
if data in a1 is the same as data in b2 then "7641" otherwise "7642" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
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" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula
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" |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
