IF functions with multiple results including blank

S

Steve

=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.
 
L

~L

Data Validation supports minimum and maximum entry lengths. Have you taken a
look at that?

You can find it in the data menu (or tab in 2007).

You can even have custom error and input messages.
 
S

Steve

Using 2003. Thanks.
--
Steve


~L said:
Data Validation supports minimum and maximum entry lengths. Have you taken a
look at that?

You can find it in the data menu (or tab in 2007).

You can even have custom error and input messages.
 
L

~L

Using 2003:
Select the range you want this rule to apply to then go to data, then
validation.

On the settings tab of the dialogue that comes up, under the allow field,
choose 'text length' then set your minimum and maximum (which can be cell
references if you want).

On the error alert tab, put "Too Many Characters"

If you are applying this to a list that has already been typed and you turn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top