If formula
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". Than...
Forum Discussion
For the last line, it gives an error for "expecting number but found text" on the "Not Included".
IF([Taxes]=0, "Not Included", $NumberInTextFormat)
------------------------------
Megan Hardison
------------------------------
IF([Taxes]=0, "Not Included", $NumberInTextFormat)
------------------------------
Megan Hardison
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThe field type should be changed to formula text. It sounds like the field type is now formula numeric.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------