Formula

P

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
 
B

Bondi

Phil said:
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
Click to expand...

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
 
Top