ExcelBanter - Functions in Excel 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Functions in Excel 2003 (https://www.excelbanter.com/excel-worksheet-functions/125253-functions-excel-2003-a.html)

Mike

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?

Roger Govier

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?

Teethless mama

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?

All times are GMT +1. The time now is 05:45 PM.