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]

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

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
(e-mail address removed)
"Phil Parker" <[email protected]>
wrote in message
news[email protected]...