“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

vlookup function to get tax deductions amount for the number of dependents listed in cell c5. use the table in h13:h17 to complete the function. The maximum deduction is 500$

Solved by F. J. in 24 mins

I am trying to come up with a spreadsheet that will break a single number down into multiple cells. The results shown in the cells will have excel minimum value of zero along with the first cell having a maximum of 20, the second cell maximum of 5 and third cell with no maximum. I have come up with solutions for the first and third but not the second cell.

Solved by A. B. in 26 mins

I have a row of measurements and need to find the maximum variance. That is the lowest number divided by the largest number. How can i write this as a formula in excel?
Example: 127 111 119 120 126 maximum variance .126
I always have 6 values in the roll and I need to calculate the maximum value for each row and find the maximum number of rows in excel

Solved by T. U. in 21 mins

Can you create an if statement to return a number with a maximum value. Even if the percentage is over 100%

Solved by E. W. in 25 mins

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.

Solved by G. C. in 19 mins