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

Adrian B

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.

JamesB

@Adrian B

This should do what you want.

=SUM(([Hotel Rate Double]@row * Tax@row) + [Hotel Rate Double]@row) / 2

JamesB

@Adrian B

This should do what you want.

=SUM(([Hotel Rate Double]@row * Tax@row) + [Hotel Rate Double]@row) / 2

Adrian B

@JamesB that totally worked! Thank you so much!!😀