Get instant live expert help on I need help with r2 value excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to plot points and find the slope and R2
Solved by I. A. in 11 mins
I want my spreadsheet take the time and date from cell H2 and R2 and Q2 and R2 and work the difference between them. But i want this time to deduct weekends and deduct any hours after a 9-5 work day. I want this all to show on Cell Z2
Solved by C. A. in 19 mins
Formula for T is =IF(P2> 0.5, S2, R2). Column P is either 50% or 70%, S is 50% Calc, R is 70% calc. When P is 50% is want S value, but am getting R??
Solved by M. Q. in 12 mins
I have a cell with a date R2, I would like to highlight all the other cell's in column R that are -14 days of the date in R2. What is the conditional formatting formula for that?
Solved by I. J. in 24 mins
I am attempting to apply the normal distribution formula to a series of numbers. I don't want to update the sequence of every single aspect formula, instead of applying the formula to the cell to the left, per the usual What I expected...you know, since the cell that contains my mean and standard deviation have not moved since I calculated them separately... =NORM.DIST(B2,R2,R4,FALSE) =NORM.DIST(B3,R2,R4,FALSE) =NORM.DIST(B4,R2,R4,FALSE) what I got instead as I applied the formula down the column... =NORM.DIST(B2,R2,R4,FALSE) =NORM.DIST(B3,R3,R5,FALSE) =NORM.DIST(B4,R4,R6,FALSE) What am I doing wrong?
Solved by O. B. in 22 mins