So here is my problem. I need to restrict entry in Cell B8 if Cell B3 AND/OR Cell B5 contain entries. Here is what I've done by way of a formula. I'm using Excel 2013
=IF(OR(B3<>"",B5<>""),LEN(B8)=0,LEN(B8)<=25)
Basically, if Cell B3 or Cell B5 are anything other than blank, Make the length of cell B8=0. If false, Make Length of B8<=25.
My problem is the true condition works fine (entry into B3 or B5 makes LEN(B8)=0) but the false condition doesn't work. I can enter as much data as I want into cell B8 if cell B3, and B5 are both blank. I'd also like to restrict entry in B8 to only Alphanumeric number. No special characters.
=IF(OR(B3<>"",B5<>""),LEN(B8)=0,LEN(B8)<=25)
Basically, if Cell B3 or Cell B5 are anything other than blank, Make the length of cell B8=0. If false, Make Length of B8<=25.
My problem is the true condition works fine (entry into B3 or B5 makes LEN(B8)=0) but the false condition doesn't work. I can enter as much data as I want into cell B8 if cell B3, and B5 are both blank. I'd also like to restrict entry in B8 to only Alphanumeric number. No special characters.
Last edited: