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

I have the following formula: =AVERAGE(C8:GY8)-35, but I want to add that when a cell shows a negative number, i.e. -2, that the cell should show 0. This is a generic golf handicap formula, and I want the lowest handicap a person can have to be zero. I've tried numerous functions; ROUND, ROUNDUP, IF, but cannot get the formula to work. What can I add to my formula to get the desired result?

Solved by O. E. in 19 mins

4. The worksheet will also show the average number of orders fulfilled for each column in the section above.
In cell B12, create a nested formula using the AVERAGE function and ROUND function in excel to first find the average number of boxed sets sold in January (the range B6:B9), and then round the answer to 0 digits.
Copy the formula from cell B12 to the range C12:N12

Solved by E. E. in 25 mins

I would like to swap the x axis an the y axis round but I can't seem to. I have tried putting the data in manually, but this does not seem to work

Solved by K. Q. in 27 mins

I have 2 sheets in my workbook.when I enter something in a cell in one, it appears also in the same cell in the other, but not the other way round. How can I stop this happening?

Solved by G. C. in 11 mins

I have a spreadsheet for my local bowling club league championship. I have IF formulas in 4 cells for each round of our competition and I have a cell to calculate the sum of the 4 cells as each round is completed. I am getting ##### until all cells are full. Can I see the sum as each individual round is completed.

Solved by A. H. in 12 mins

I have an excel spreadsheet for a rugby competition with multiple sheets that is running a vba code to sort group tables automatically when match results are entered and then return which teams progress to the next round.
The vba code to sort the teams works. However, there is an issue with then using the scrollbar to select an input cell. The cell selected is always the one which would be in the original view and not the view I'm in.
Example: If A1 is in the top left corner of the screen and then I scroll to make AB11 the top left cell. I would then select AB11 and the computer would instead select A1.
How do I amend the vba code to fix?

Solved by O. L. in 22 mins

Regard excel round down problem. The cell already uses an IF(ISNA) type formula and I basically want to also add to the formula that if the result is under 100, and is divisible by 10, then it needs to round down by 5, so 30 becomes 25 e.g. In addition to that, if the result is divisible by 100 i.e. 200, 500, 700, then I want it to round down by 5 to e.g. 195, 495 or 695

Solved by S. Q. in 15 mins

I have column with numbers.
I'd like to multiply all decimal numbers by 4.
I'd like to round some of them before.

Solved by I. W. in 29 mins

How do i round numbers in excel?

Solved by O. W. in 28 mins

I need to round to two decimal places. Help!!!

Solved by G. H. in 26 mins