Excel formula help
Closed
Ahmed
-
Jun 20, 2010 at 05:16 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 20, 2010 at 07:51 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 20, 2010 at 07:51 PM
Related:
- Excel formula help
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 20, 2010 at 07:51 PM
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.
=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.
