Goal: Calculate Character count limits for ppc ad sheet.
Character Count field is the number of words in the copy for that ad
Character Limit is the number of words allowed in the ad
IF({Character Count} < {Character Limit}, “ 
PASS”) IF({Character Count} = {Character Limit}, “ PASS”) IF({Character Count} > {Character Limit}, “ 
FAIL”)
Please help! Thanks in advance
IF() statements have an implicit “else” portion as a final clause. You can also check for “less than or equal to.” So your formula should be
IF(
{Character Count} <= {Character Limit},
"PASS",
"FAIL"
)
Thank you so much! Really appreciate your help with this…
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.