Get instant live Excel expert help to learn how to find range in Excel

I need the formula for: Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will receive no additional deductions.

Column A has been given the named range Surname and column B the named range Given_Name. These named ranges must be used in your solution. I do not know how.

Just need some macro help 1)Get the macro to move to a particular cell - use C3.(the Range statement) 2)Fill the cell with a value 3)Store the value in a variable (call it x) 4)Move to the top of an empty column 5)Set up a loop to fill the column with x occurrences of your name 6)Fit the column width to the text (Autofit) 7)Get the macro to ask whether you would like to run again 8) Set up a statement which will go back to the start if you answer Yes

In cell E11, enter a financial function to calculate the interest paid. Copy the formula to the range E12:E34. The result should be a positive value. In cell F11, enter a financial function to calculate the principal payment. Copy the function to the range F12:F34. The result should be a positive value. In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format.

In cell D11, enter a formula to reference the value stored in cell E2. Insert a formula in cell D12 that references the ending balance for the previous payment row (G11). Copy the formula in D12 to the range D13:D34.

can you explain why in the sales worksheet, vlookup function in column E range lookup is 0 while in column H the range lookup is true. what's the difference?

I need a formula to conditionally format a range. The values in the range that need to be formatted, must be more than 5% greater than the average of the range. The range is $G$2:$G$11 I don't know how to represent the greater than 5% with the average of the range and what operator to place in between. Thank You

I need to find to calculate the 25% percentile of a range of values with certain conditions on a table. This is what i have so far but it seems to have an error somewhere, =PERCENTILE(IF('906-Try'!F:F>'2019 Goals'!K2,IF('906-Try'!T:T>'2019 Goals'!K3,IF('906-Try'!O:O>'2019 Goals'!K4,IF('906-Try'!C:C>=MIN('2019 Goals'!K5,'906-Try'!C:C<=MAX('2019 Goals'!L5)))))),25%)

I need to change a pivot table macro. How do I do this?

apply the input cell style to the range B3:B6,E3:E4,and E6:E7,and then apply the calculation cell style to cell E5. Part of the borders are removed when you apply these styles. how to do this step in Mac