Implementing a simple formula

On the column: Input est. ERC Amount, the amount is $20,000 so on the column Your Estimated Commission should display $300 which is a commission of 1.5% . I have used this two formulas but won’t work:

{Input est. ERC Amount} * (1.5 / 100)

MULTIPLY(0.15,{Input est. ERC Amount})

Please let me know what is the correct formula.


You were VERY close! in fact, your first formula should have worked, so I’m not sure what the error was there. With your second formula, you accidentally multiplied by 15% instead of 1.5%.

What are your column types?

image