If then with % and #

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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 ($)

Photo of Daniela

Daniela

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
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?
Photo of Daniela

Daniela

  • 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")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,944 Points 50k badge 2x thumb
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.