Formula

[Phil Parker]

Does any one know how to write formula where if cell 1 is the same as cell 2 then the value of cell 3 is entered in to cell 4

[Bondi]

Phil Parker wrote:
> Does any one know how to write formula where if cell 1 is the same as
> cell 2 then the value of cell 3 is entered in to cell 4
>
>
> --
> Phil Parker
> ------------------------------------------------------------------------
> Phil Parker's Profile: http://www.excelforum.com/member.php...o&userid=35064
> View this thread: http://www.excelforum.com/showthread...hreadid=548086

Hi Phil,
For that to happen you would have to put something like this in cell 4:

=IF(A1=B1,C1,"What Ever When A1<>B1")

Regards,
Bondi

[Don Guillett]

for a formula, try in a4
=if(a2=a2,a3,"")

--
Don Guillett
SalesAid Software
[email protected]
"Phil Parker" <[email protected]>
wrote in message
news:[email protected]...
>
> Does any one know how to write formula where if cell 1 is the same as
> cell 2 then the value of cell 3 is entered in to cell 4
>
>
> --
> Phil Parker
> ------------------------------------------------------------------------
> Phil Parker's Profile:
> http://www.excelforum.com/member.php...o&userid=35064
> View this thread: http://www.excelforum.com/showthread...hreadid=548086
>