Skip to main content
Question

Can I use an "if" formula with numeric fields?

  • September 16, 2020
  • 0 replies
  • 123 views
Forum|alt.badge.img+7
Hello, I am trying to use an "if" statement for a formula in a Formula - Numeric field.  I am getting the error: "Expecting bool but found number."

I understand what that means, but I don't understand how to write the formula to fix it.

Here is the formula:

IF (([Numeric field #1] - [Numeric field #2] + [Numeric field #3]) > ([Numeric field #1] * 0.25), ([Numeric field #1] * 0.25), ([Numeric field #1] - [Numeric field #2] + [Numeric field #3]))​

Any help you could provide would be greatly appreciated!

------------------------------
Josh Collins
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
If you want a numeric result then you will need to change the field type to be formula numeric.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
  • AustinK
  • Registered
  • September 16, 2020
Without changing anything in your formula it worked for me. When I copied it over it did have a weird red highlighted character at the end but I just deleted that, you may or may not have that in yours.

Are you positive these are Numeric fields(not Numeric - Currency, Numeric - Percent, etc) and that you are working with a Numeric Formula field? It sounds kind of like it may be a Formula Checkbox.
Terms & ConditionsAccessibility statement