How Can I Multiply 2 fields and then divide in 1/2?

I am trying to calculate two fields in SmartSheet (a dollar amount by a tax percentage in decimal format). I then would like to divide the calculation in half. For example, I would like my hotel rate $109 times the tax rate of 12% to be multiplied together to get the total hotel rate and then divide that total rate in half. When I try, I just keep getting errors.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!