Excel formula help

Closed
Ahmed - Jun 20, 2010 at 05:16 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 20, 2010 at 07:51 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 20, 2010 at 07:51 PM
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.
0