DATA VALIDATION question

[daniels012]

I have this under a custom data validation:

=IF(LEN(B5)+LEN(B16)+LEN(B8)+100>180,TRUE,FALSE)

why would this not be working?
I am trying to make sure that they don't enter over 180 characters in these 3 cells plus 100 characters reserved for the directory.

thank you,
Michael D

 

[T. Valko]

I have this under a custom data validation:

=IF(LEN(B5)+LEN(B16)+LEN(B8)+100>180,TRUE,FALSE)

why would this not be working?
I am trying to make sure that they don't enter over 180 characters in these 3 cells plus 100 characters reserved for the directory.

thank you,
Michael D

The formula is returning TRUE if the total LEN is >180. You probably want it to be <=180.

=LEN(B5)+LEN(B16)+LEN(B8)+100<=180

 

[daniels012]

Thank you!

I guess I was thinking backwards... which is happening a lot lately.

Michael

 

[T. Valko]

Thank you!

I guess I was thinking backwards... which is happening a lot lately.

Michael

You're welcome. Thanks for the feedback!