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

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.

Solved by F. A. in 17 mins

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.

Solved by F. F. in 16 mins

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

Solved by A. L. in 16 mins

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.

Solved by S. H. in 13 mins

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?

Solved by V. D. in 13 mins

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

Solved by B. Y. in 19 mins

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

Solved by S. D. in 12 mins

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

Solved by F. B. in 12 mins

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

Solved by F. D. in 13 mins

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

Solved by I. S. in 19 mins