Forum Discussion
IF Statement for Multiple conditions
I am working on a template that will take phone number data and reformat it based on the below conditions: Phone # should contain 10 digits - If < than 9 flag with "invalid" - If 9 insert a 0 - ...
Hallo Deb
My interpretation.
=SWITCH(LEN(A5),8,"invalid",9,0&A5,10,A5,11,IF(ISNUMBER(SEARCH(61,A5)),SUBSTITUTE(A5,61,0),"invalid"),"invalid")&""