Question: I am confused on how to set up this function m. Enter Monthly Taxes in cell S1. Enter a formula in cell S2 to calculate

I am confused on how to set up this function  I am confused on how to set up this function m.
Enter "Monthly Taxes" in cell S1. Enter a formula in cell S2

m. Enter "Monthly Taxes" in cell S1. Enter a formula in cell S2 to calculate the monthly taxes. Since each development has a different tax rate, you need to use the VLookup function with the Development ID to retrieve the development's Tax Rate from the Development worksheet. This lookup is exact, so you need to use FALSE for the fourth argument of the VLOOKUP function. To determine the actual tax, multiply the tax rate by the sold price, and divide the tax by 12 . To reference a lookup table on a different worksheet, click on the worksheet tab that contains the lookup table, select the range, type a comma (,), and then click the original worksheet tab. Edit the formula to use a mixed reference for the lookup table to fix the rows. Copy/Paste or fill this formula to the remaining cells in column S for the details of property listings

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!