Need Help with data validation dependent on multiple cells- Formula only can't use VB

Luq07

New Member
Joined
May 4, 2015
Messages
1
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.
 
Last edited:

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top