Skip to main content
Question

Formula - Total field if/then based on numeric value and percent.

  • October 24, 2019
  • 0 replies
  • 63 views
I have attached a photo of a formula I have been working on. A bit of background information: I will use this to create an estimate for clients for some of our products. This formula field will display our fee based on the total cost the the Estimate Cost field. The first few statements are based on cost with a flat fee associated. After $3000.00 the costs will be based on percentage. It worked until I added the percentage portion. I've written it a few times, and after so many times of staring at it I can't seem to get it right. Please help :)

------------------------------
Anna Harris
------------------------------
This topic has been closed for replies.

  • AustinK
  • Quickbase Alumni
  • October 24, 2019
Best bet to get quicker help is to post the actual formula as text so people can copy and paste it. Also is this a text field? I am guessing text as the numbers have quotes around them but it would be good to know for sure.

With an offhand guess I would wrap the yellow text in a ToText function.
Terms & ConditionsAccessibility statement