Skip to main content
Question

If formula

  • October 19, 2020
  • 0 replies
  • 47 views

I need help writing a formula please. Hopefully super easy...

If([Add 7% tax]=true,[7 Percent Tax Formula],[Taxes])

But then I want to add that if [Taxes]=0, then display "Not Included".

Thanks so much!

------------------------------
Megan Hardison
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
Megan,
The challenge here is that when you define a formula field in QuickBase it needs to be a type like Text or Numeric.  You seem to be wanting a result which is sometimes numeric and sometimes text.

In your use case can you have a formula numeric field that will calculate to a numeric result and then have a separate text field to put in the form that says "Taxes not included".   That's the easy way through this.

There is a way to coax the numbers into a text field if you want to pursue that direction, but it will  be more complicated than you expected.  But we can go down that path together if you want to work your way through it on this Forum.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------