Putting result of formula in another cell 1

[jpl458]

I want to compare two cells in an excel spreadsheet and if they are the same I want to concatenate two cells and put them in the cell different from the formula location. Example

=IF((B2 = B3),R3=CONCATENATE(G2,G3),"")

I tells me false.

Windows 7
Office 10

Thanks in advance
jpl

 

[Deniall]

Why cannot the formula be in the cell where you want the result put (R3 in your example)?[ ] That is what a formula is intended to be used for.[ ] A formula is not allowed to influence a cell other than the one (or ones) in which it is located.[ ] If you really need to do what you seen to be suggesting, you will need to use VBA.

I assume you can see why the example formula you give in your post is returning FALSE (into the cell it is located in).