How to show cell content and hide cell content? If cell B3 there is a content, the content of cell A3 will be shown. If B3 is empty so the content of A3 will be hidden.
How to show cell content and hide cell content? If cell B3 there is a content, the content of cell A3 will be shown. If B3 is empty so the content of A3 will be hidden.
Try this
=IF(B3<>"",A3,"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
where should I input the formula?
Well, since you reference two cells, the formula should be written in and any cell other than A3 or B3.
Let's say C3
Row\Col A B C 3 5 1 5
thanks so much, problem solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks