Hey Austin, thanks for the reply.

You're correct, I didn't accurately give you the field type.

Numeric Field #1 is actually "Formula - Currency"

Numeric Field #2 is actually "Formula - Currency"

Numeric Field #3 is actually "Currency"

Would it be as easy as changing these to the type "Formula - Numeric" and "Numeric" and then just displaying the result as currency instead of simple number?

Thanks!

------------------------------

Josh Collins

------------------------------

Original Message:

Sent: 09-16-2020 16:04

From: Austin K

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

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.

Original Message:

Sent: 09-16-2020 15:24

From: Josh Collins

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

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

------------------------------