I would like to combine the following Excel formulas in the custom data validation field:
=IF(AND(ISNUMBER($B$55)),OR($AH$55=5,$AH$55=9),IF('Sheet1'!$D$5=0,FALSE,IF('Sheet2'!$B$6="Incomplete",FALSE,IF($AF$263<9,FALSE,TRUE))))
And if a 9-digit zip code is typed in, I would like a hyphen to appear between the first 5 digits and the last 4 digits.
I've considered combining this formula with the aforementioned IF function, but I'm not sure how that would work:
=REPLACE($B$55,6,0,"-")
Or, placing the aforementioned REPLACE function cell in AJ55 and have something like the following:
=IF(LEN($B$55)=9,$AJ$55))
Thank you in advance!
Bookmarks