ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/217465-formula.html)

Donna

Formula

What is the formula for:
if data in a1 is the same as data in b2 then "7641" otherwise "7642"

Kevin B

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"

Donna

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"

David Biddulph[_2_]

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"

All times are GMT +1. The time now is 07:05 PM.