| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |
|
|
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
