Thread
:
Data Validation - Complex Q
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Data Validation - Complex Q
Hi Sean,
Am Sat, 2 Feb 2013 03:15:12 -0800 (PST) schrieb
:
1) If value in K10 = "C/D", then (2) below does not apply
2) A value is already entered firstly in J10
3) The value being entered in H10 has a max of 2 decimal places, eg user can enter 1000 or 1000.12, but not 1000.123
try:
=AND(OR(LEN(J10)0,K10="C/D"),LEN(H10)<=LEN(INT(H10))+3)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch