Author Question: Name two ways a SUTA tax rate of 3 could be stored in a cell in Excel to be used in ... (Read 727 times)

mp14 · **on:** Jun 24, 2018

Name two ways a SUTA tax rate of 3 could be stored in a cell in Excel to be used in calculations.

Question 2

The assessed value of a property is in Cell B8 of a spreadsheet and the tax rate per 100 of assessed value is in Cell C6. What formula could be entered in Cell F8 to calculate the tax due? Use an absolute cell reference.

KKcool · **Reply #1 on:** Jun 24, 2018

Answer to Question 1

1.) It could be entered as the number 3 with the cell formatted as a percent.
2.) It could be entered in decimal form as 0.03.

Answer to Question 2

=(B8/100)C6