Get instant live Excel expert help to learn how to create a statistical function in Excel?

Hi, see yellow highlight in columns CH and CJ. Is it possible to add a formula to count the number in each quartile? CH is a count column AB quartiles, and CJ is a count of X quartiles.

Hi WF was helping me last night with a count on quartiles. The quartile 1 formula was done and appears right in CH8 but I still can't work out how to do the countif formula for quartiles 2, 3 and 4.

Click the Wait Time worksheet and enter a function in cell F6 that calculates the wait time value of the first quartile.

Click the Wait Time worksheet and enter a function in cell F6 that calculates the wait time value of the first quartile. In the Cell 'F6' of Sheet 'Wait Time', the 'Formula Function Name Text' was not set as per instruction.

A1= 19.13 B1= FLAT C1= Formula =IF(A1<=20,"PASS","FAIL") However if B1=House the formula required is as follows =IF(A1<=30,"PASS","FAIL") How do I write the formula in C1 to take account of the variation in cell B1?

I would like to have a nested if that makes a variation in transportation cost following this principle IF F*B+S<3 then T=14 IF F*B+S<6 then T=8 IF F*B+S<12 then T=5.66 IF F*B+S<20 then T=1.5 IF F*B+S=>20 then T=0

i need to remove duplicates in certain groups of cells. Variation 1 and Variation 2 based on the item name.

I had some help this morning on the attached spreadsheet, however I need more formulas to link together. In column L I have a formula; =IF(AND(H3="Budget",I3="MS-SC (MU)"),K3+20,IF(AND(H3="Firm"),K3+40)) however I need it to add multiples on i.e; =IF(AND(H3="Budget",I3="MS-SC (W)"),K3+20,IF(AND(H3="Firm"),K3+40)) also add on ; =IF(AND(H3="Firm",I3="Variation"),K3+10, can this be done? so it looks like the below but actually works... =IF(AND(H3="Budget",I3="MS-SC (MU)"),K3+20,IF(AND(H3="Firm"),K3+40)),=IF(AND(H3="Budget",I3="MS-SC (W)"),K3+20,IF(AND(H3="Firm"),K3+40)),=IF(AND(H3="Firm",I3="Variation"),K3+10

have a workbook that is used to calculate multiple items over 40 sheets. On my balance sheet, in excel 2013 I would hit F9 and could see all the calculations take place in the spreadsheet. The numbers changing rapidly. I upgraded to Excel 2016 and when I hit F9 I see the calculations happening in the bottom right task bar but my balance sheet doesn't change. I need to see the changes in real-time like before. I have checked all my settings side by side and all are the same. I have tried every variation excel of alt-Shift-CRTL f9 there is and nothing. It seems like this should be a check box somewhere saying show calculations

I'd like to copy all of one sheet into another workbook into cell A2, no variation of copying and pasting will allow me to do this, really annoying