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

I want to work out average in excel, max and min for each month over time. I have 5 years worth of data. Please help!!!

Solved by G. A. in 20 mins

I am trying to place a band into a chart, the min is 4 and the max is 10. when the band appears on the graph the min is 4 and the max 14? why cant i have the band reflect the 10 that i need to be represented in the graph

Solved by S. A. in 19 mins

Hello,
i have a column with several numbers. In a second column, i want the total of the first column, but only until the biggest number in the first column.
Imagine, the numbers are from B1:B8. In the second column, i wanted to use "=Sum(B2:Max(B2:B8))"...but it doesnt work. Can you help me

Solved by G. H. in 16 mins

I need a formulas using only this functions , Mod
IF
and
or
round
roundup
sqrt
min
max
sin
cos
to figure out how many hrs does a take to do a job
Example. 10 to 20k 30 hrs
20001 to 30 k 60 hrs
and so on increments of 10 k increments of 30 hrs

Solved by D. H. in 30 mins

Column C contains numbers only from rows 9 to 21. These could be either whole numbers - 1, 2, 3 etc or decimal numbers 3.5, 4.2 or 5.0. Minimum is 1 max is 5. If a cell C9 - C21 does not have a number then Cell H21 to insert 'ERROR' and conditional format cell to warning colour - red.

Solved by A. J. in 23 mins

I got the following formula in my latest session:
=_xlfn.MAXIFS(Q:Q;C:C;C2)
But Excel 2016 does not have the maxifs function anymore, I need some help with changing to MAX(IF(

Solved by G. A. in 23 mins

I am trying to set up a spreed sheet in excel to automate cutting lits generation .
but i can not work out how to find, a formula to return how many results i have between set figures.
I.e. if the min is 1000mm and max is 1500mm how can i find out all numbers between them ?

Solved by V. D. in 29 mins

I need a formula to nest letter grades based on a grading system of percentages with A being above 90% of the max score of 80, B above 80%, C above 70%, and an F below 70%

Solved by A. E. in 25 mins

I have two separate MAX formulas in cells M19/M20.#
i wish to have both formulas in a MAX fuction in M19.

Solved by C. S. in 24 mins

I need help with a formula.
Data:
Extra person charge : 800
Max of 4 people in 1 room
Only have extra charge if there is a 3rd and/or 4th person in the room
Eg. 1 room, 3 adults = 800 extra person charge
2 rooms, 5 adults = 800 extra person charge
2 rooms, 7 adults = 2400 extra person charge
I need help with making a formula to satisfy all the requirements so Ill be able to monitor the total income from each booking

Solved by M. C. in 15 mins