# If then with % and #

• 0
• Question
• Updated 3 years ago

i have a formula and i keep getting sintax errors.

Im not sure if its because its % and text and #

IF(

[Estimated Professional Fees]>=150000, and [Variance from Last Estimate (%)]>=10, "Yes"

[Estimated Professional Fees]>=150000, and [Variance from Last Estimate (%)]<=-10,"Yes",

[Estimated Professional Fees]<=150000, [Variance from Last Estimate (\$)

• 0 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 67,670 Points
Aside from a missing comma and missing the end of your formula - can you tell me the field type that this is - presumably it is a formual text field.  If so, the result of the formula must be text.

What result in words are you looking for if the variance is say zero?
• 0 Points
its a formula - text and im still getting syntax errors

IF(

[Estimated Professional Fees]>=150000, and [Variance from Last Estimate (%)]>10,"Yes",

[Estimated Professional Fees]>=150000, and [Variance from Last Estimate (%)]<-10,"Yes",

[Estimated Professional Fees]<150000, and [Variance from Last Estimate (\$)]>15000,"Yes",

[Estimated Professional Fees]<150000, and [Variance from Last Estimate (\$)]<15000,"Yes")

QuickBaseCoach App Dev./Training, Champion

• 67,670 Points
Ah, sorry, I'm blind.  you need to get rid of those commas in the middle of each line

IF(

[Estimated Professional Fees]>=150000 and [Variance from Last Estimate (%)]>10,"Yes",

[Estimated Professional Fees]>=150000 and [Variance from Last Estimate (%)]<-10,"Yes",

[Estimated Professional Fees]<150000 and [Variance from Last Estimate (\$)]>15000,"Yes",

[Estimated Professional Fees]<150000 and [Variance from Last Estimate (\$)]<15000,"Yes")

( you will likely also need to change those 10's to 0.10 to get the logic to work for you.