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
|