Excel formula help

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
Dear Sir
I am beginner in excel i have a question i want in a cell if i type a number in a cell and press enter the cell should contain "hello world" insted of 2, plz advise simple formula and how to do this.




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
if you are typing 2 in cell A1, and want "hello world" to appear in cell B1, then in b1 you need to enter a formula
=if(a1=2, "hello world", "")

it says
if a1 is 2, then show hello world
if a1 is not 2, then show nothing or a blank string


now if you are typing 2 in cell a1, and want hello world to appear in a1 itself, then you have to use macro.