If formula

Question

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
------------------------------

markshnier__you · Answer

Megan,The challenge here is that when you define a formula field in QuickBase it needs to be a type like Text or Numeric.&nbsp; 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".&nbsp; &nbsp;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&nbsp; be more complicated than you expected.&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

meganhardison · Answer

Yes, I can do the easy way, but I need EF+ to display on the printout "Taxes not included" if its $0. Maybe its a formula with the EF+ form itself?

------------------------------
Megan Hardison
------------------------------

markshnier__you · Answer

OK, I get it.&nbsp; I will post back later when I get a chance.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

I have not tried this in the formula editor but try this// calculate the numeric valuevar number TaxesCalc =&nbsp;If([Add 7% tax]=true,[7 Percent Tax Formula],[Taxes]);// turn the calculated value into text with two decimals.var number Value = Round($TaxesCalc,0.01) ; var text Decimals = "." &amp; PadRight(Right(ToText(Int($value * 100)),2),2,"0");var text Thousands = If($Value&gt;=1000,ToText(Int($Value/1000)));var text Hundreds=Right(ToText(Int($Value)),3);var text NumberInTextFormat =If($Value&lt;0, "-")&amp;List(",",$Thousands,$Hundreds) &amp; $Decimals;// decide which to showIF([Taxes]=0, "Not Included", $NumberInTextFormat)// if the formula does not work and your can't debug it, please post your formula and the error message------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

meganhardison · Answer

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
------------------------------

Forum Discussion

If formula

Related Content

Delete Formula Button Error

Formula Assistance

Formula Url Buttons

URL formula -API_RunImport

Formula Query with custom key