Chris72
Board Regular
- Joined
- Jun 11, 2007
- Messages
- 115
Hi,
I have the following as part of a larger nested IF statement:
IF(AND(GU31='Drop Downs'!E5,OR(GZ31=A2,NOT(LEN(SUBSTITUTE(GZ31," ",""))=11),NOT(ISNUMBER(SUBSTITUTE(GZ31," ","")+0)))),A8&" - "&GZ27&" - MUST BE 11 DIGITS",
Where:
GU31='Drop Downs'!E5 -> GU31="Yes"
GZ31=A2 -> GZ31="No Input"
GZ31 can be either A2 or a Number... when seperated from the nested IF as above the formula works perfectly... but when added to the Nested If statement it returns #NAME?
Is there a solution?
Chris...
I have the following as part of a larger nested IF statement:
IF(AND(GU31='Drop Downs'!E5,OR(GZ31=A2,NOT(LEN(SUBSTITUTE(GZ31," ",""))=11),NOT(ISNUMBER(SUBSTITUTE(GZ31," ","")+0)))),A8&" - "&GZ27&" - MUST BE 11 DIGITS",
Where:
GU31='Drop Downs'!E5 -> GU31="Yes"
GZ31=A2 -> GZ31="No Input"
GZ31 can be either A2 or a Number... when seperated from the nested IF as above the formula works perfectly... but when added to the Nested If statement it returns #NAME?
Is there a solution?
Chris...
Last edited: