Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in Excel 2003
How can I get an ISTEXT function to return the value I want in the cell
instead of TRUE or FALSE? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in Excel 2003
Hi Mike
=IF(ISTEXT(A1),"Value if True","Value if False") Substitute what you want the cell to return -- Regards Roger Govier "Mike" wrote in message ... How can I get an ISTEXT function to return the value I want in the cell instead of TRUE or FALSE? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions in Excel 2003
=--ISTEXT(A1)
"Mike" wrote: How can I get an ISTEXT function to return the value I want in the cell instead of TRUE or FALSE? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel 2003 files in Excel 97 | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |