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

How to calcylate interest rate. I'm trying to figure out a interest rate over 10 years at 7% and initial investment of 5000.... cant seem to get the absolute formula to work

Solved by A. E. in 24 mins

SUMPRODUCT FORMULA IN EXCEL
1 2 3 4
Qty Rate Qty Rate Qty Rate Qty Rate
10 200 5 190 5 180 5 180

Solved by A. A. in 26 mins

Hi, I need a formula that will apply a percentage rate to the calculation depending on the number of years.
Ex: If a staff has worked for 15years or more, a 2% Tax rare is applied to the Gross Benefit.
or
If a staff has work for 0-5 years only, a 15% Tax rate is applied.
Please help

Solved by G. Q. in 29 mins

I need to use a formula or combination of formulas to return a value (pay rate) based on whether I put in "ST Rate, OT Rate or 1.5x Rate" and also based on Employee name.

Solved by M. L. in 26 mins

I am trying to calculate the time needed to accumulate $500K in a 401K account using a fixed interest rate and a fixed investment per month. I can't get the NPER excel formula to work. I need some help. Please.

Solved by Z. J. in 28 mins