Formula Syntax Error
I keep getting a syntax error for the current formula. Any ideas what I am missing? If([Measure]="M&V" or [Measure]="Modeled" or [Measure]="Post measurement", If([PercentChange1]=0 and [PercentC...
Forum Discussion
You are missing about 20 closing brackets.
Quick Base, unlike Excel, does not need all those IFs. Normally you just need 1. That way you do not have to go cross eyed in matching them up.
But also the logic ion your formula does not make sense.
If suggest that you rewrite it like this
IF(
some condition is true, result 1,
some other condition is true, result 2,
Yet another condition is true, Result 3, Result 4)
Quick Base, unlike Excel, does not need all those IFs. Normally you just need 1. That way you do not have to go cross eyed in matching them up.
But also the logic ion your formula does not make sense.
If suggest that you rewrite it like this
IF(
some condition is true, result 1,
some other condition is true, result 2,
Yet another condition is true, Result 3, Result 4)