Posted to microsoft.public.excel.misc

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

How do if create IF functions using text as the logical test?

=IF(A1="string","text in A1","no text")

=IF(ISTEXT(A1),"text","no text")

Either one will do.

Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 10:27:02 -0800, nellybean
wrote:

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert a month to a quarter ......	Epinn	New Users to Excel	26	May 3rd 23 07:45 PM
Sumproduct issues	SteveDB1	Excel Worksheet Functions	25	June 3rd 09 04:58 PM
Copy from a Cell to a text box.	AJL	Excel Worksheet Functions	9	November 7th 06 04:58 PM
How to create a Pivot table from text file with more than 65000 rows?	morchard	Excel Discussion (Misc queries)	0	June 29th 05 08:50 PM
change text color based on logical test	T3nMan	Excel Worksheet Functions	1	January 19th 05 04:30 PM

All times are GMT +1. The time now is 09:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us