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

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

=((2010 rate 2005 rate)/2005 rate)*100.

Solved by X. J. in 24 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 need to calculate the passing rate using a formula.

Solved by C. U. in 27 mins

I'm trying to create a formula that the amount should be $2.50; however, it's not working. What am I doing wrong? .27/2+.27*6.1 (rate divided by 2 + rate is OT rate times 6.1 which is the overtime hours).

Solved by D. Y. in 28 mins