Ensure Cell Only Accepts x Characters

    hi!


    my formula is in B1. If in A1, there is letter Y, the value in B1 should accept only 3-digit numbers.


    guys, can you help me with the formula?


    Any help is very much appreciated.


    Thank you so much.

    Re: Cell Accepts 3-digit Numbers Only


    Hi iiawak,


    This is my suggestion. Apply data validation in cell B1. Choose the "custom" type and under formula, type "=IF(A1="Y",LEN(B1)<=3,LEN(B1)>0)" (without the quotes).

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login