IF functions with multiple results including blank

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1,814

IF functions with multiple results including blank

=IF(LEN(C3)<=D3,"Entry Acceptable","Too Many Characters")
C3 starts off empty and is an input field. D3 is the maximum number of
characters including spaces allowed.
Trying to add another step to formula that if cell C3 is blank/empty no
result would be shown.
--
Steve

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
Index & Match functions - multiple criteria and multiple results	[email protected]	Excel Worksheet Functions	4	May 2nd 07 03:13 AM
Obtaining Multiple Results Using Index/Match Functions	Archie999	Excel Worksheet Functions	1	March 3rd 07 07:57 AM
Obtaining Multiple Results Using Index/Match Functions	Teethless mama	Excel Worksheet Functions	0	March 3rd 07 03:16 AM
Obtaining Multiple Results Using Index/Match Functions	Archie999	Excel Worksheet Functions	1	March 3rd 07 03:14 AM
Advanced Filter for multiple criteria, including blank cells	Striperon	Excel Worksheet Functions	3	November 9th 06 06:33 PM

All times are GMT +1. The time now is 10:07 AM.

Menu

About Us