Simplest is to just call both functions:

Public Function Account(x)
Account = CCPA(x) & (MAJUSCULE(x & MAJUSCULE(RIP(x))))
End Function