Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions with multiple results including blank
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. "Steve" wrote: =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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions with multiple results including blank
Try this:
=IF(C3="","",IF(LEN(C3)<=D3,"Entry Acceptable","Too Many Characters")) -- Biff Microsoft Excel MVP "Steve" wrote in message ... =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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions with multiple results including blank
Using 2003. Thanks.
-- Steve "~L" wrote: 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. "Steve" wrote: =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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions with multiple results including blank
Thank you. This provided the result I was looking for.
-- Steve "T. Valko" wrote: Try this: =IF(C3="","",IF(LEN(C3)<=D3,"Entry Acceptable","Too Many Characters")) -- Biff Microsoft Excel MVP "Steve" wrote in message ... =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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions with multiple results including blank
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 on the formula auditing toolbar, there will be a button for circle invalid data. If you click it, all entries greater than D3 will be circled. "Steve" wrote: Using 2003. Thanks. -- Steve "~L" wrote: 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. "Steve" wrote: =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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions with multiple results including blank
Thank you. This was another way of relaying info back to end-user.
-- Steve "~L" wrote: 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 on the formula auditing toolbar, there will be a button for circle invalid data. If you click it, all entries greater than D3 will be circled. "Steve" wrote: Using 2003. Thanks. -- Steve "~L" wrote: 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. "Steve" wrote: =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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF functions with multiple results including blank
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Steve" wrote in message ... Thank you. This provided the result I was looking for. -- Steve "T. Valko" wrote: Try this: =IF(C3="","",IF(LEN(C3)<=D3,"Entry Acceptable","Too Many Characters")) -- Biff Microsoft Excel MVP "Steve" wrote in message ... =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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
Advanced Filter for multiple criteria, including blank cells | Excel Worksheet Functions |