HOW CAN CELL1=CELL2 AND CELL2= CELL1 at d same time

Originally Posted by AFEEZ11

but can i do dis using if statement and sm other functions bcos i dont really understand d code

No. A cell can either contain an entered value, or it can contain a formula, but it cannot contain both.

My usual approach to this sort of thing is to designate one of those cells as the input cell. Then cell2 can easily be =cell1. The instructions with the spreadsheet should explain that the data should be entered into cell1. If your users are bad at following instructions, you can protect cell2 so that they cannot (easily) edit cell2, which should force them to make their data entry in cell1.

In order to get this "bidirectional link", you must use VBA the way that Patronus has suggested. I would suggest that you need to decide how important the bidirectional link is. If it is important enough, then you need to learn how to use code like this. If it is too much work right now to learn the code, then you need to designate one of the cells as input and protect the other so that users cannot edit it.