IF ( LEN statement in Excel

DebbieV

Registered User.
Local time
Today, 06:17
Joined
May 7, 2002
Messages
63
Having trouble using the correct syntex to display in an excel spreadsheet

Would like the word WRITE to display in a cell if the length of characters >6 if not would like for it to display SAYNO

=IF (LEN A2 >6, "WRITE", "SAYNO"

Thanks in advance
Debbie
 

Users who are viewing this thread

Back
Top Bottom