Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display text automatically
I need to enter a text in A1 if i enter text in B1.
In other words, if I enter any text in B2 I want A1 to display "OPEN" Thank you for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display text automatically
in A1:
=IF(istext(B1),"OPEN","") "OKY" wrote: I need to enter a text in A1 if i enter text in B1. In other words, if I enter any text in B2 I want A1 to display "OPEN" Thank you for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display text automatically
=IF(B1="","","OPEN")
I don't know how B2 got into the picture but maybe a typo? Gord Dibben MS Excel MVP On Thu, 27 Aug 2009 08:02:06 -0700, OKY wrote: I need to enter a text in A1 if i enter text in B1. In other words, if I enter any text in B2 I want A1 to display "OPEN" Thank you for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display text automatically
If you really mean text and not numbers:
in A1: =IF(ISTEXT(B1),"OPEN","") But if you mean anything at all instead of just text: =IF(B1="","","OPEN") -- Kind regards, Niek Otten Microsoft MVP - Excel "OKY" wrote in message ... I need to enter a text in A1 if i enter text in B1. In other words, if I enter any text in B2 I want A1 to display "OPEN" Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display last entry into a cell automatically | Excel Worksheet Functions | |||
First day and Last day of the month to display automatically | Excel Discussion (Misc queries) | |||
Automatically display sentence. | New Users to Excel | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions | |||
In Excel how can a number automatically display in text form | Excel Worksheet Functions |