Get instant live Excel expert help with AVERAGE Function

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi I need to understand the following formula, ==IF(C15>0,(C15/(1-C12)*$C$5),"") Cell C15 is the total cost of a product, Cell C22 is the gross margin of the cost of the product and the cell is formatted in a percentage which is added on to the cost. I would like to know why in the formula is it 1-C22, what does the 1 mean?
Solved by B. J. in 24 mins
HI, is there a way of making a table within a table? so what i mean by that is if i need column A to be a big column for the top part but i need column a to be a small column down below id this possible and if so how do i do it ?
Solved by S. D. in 22 mins
Solved by O. J. in 25 mins
Hi i am trying to find the mean of a data and i keep getting #DIV/0 , how can i get rid of this?
Solved by E. A. in 26 mins
I need to calculate the chat time (the elapse between the first message and the last message) of a chatbox over a large number of conversations and calculate the mean of the chat duration
Solved by F. Q. in 11 mins
hi, i am helping others purchase products overseas and will add 10% markup to the original price. i want to use excel to record all the revenues and expenses to determine if it's worth doing it, if the revenue i received is more than the expenses but i am not sure if my spreadsheet is correct or not especially the sales spreadsheet, i find that the information in sales spreadsheet is too much and complicated. i need to find the revenue i get after 10% markup - before 10% markup, if it's more than 0 means i have extra profit, if it's 0 mean breakeven
Solved by O. Q. in 27 mins
Hello I'm trying to create a data validation for a particular column and i'm a bit stuck at a certain point. I have been reading your help section and it says to choose what we want allowed. I selected the option of date. but unfortunately the help section does not really describe what all the different data settings mean. I would just like for the person working on the document to be able to add any date they would like but i'm not sure what i'm supposed to select for data
Solved by I. F. in 22 mins
According to the National Center for Health Statistics, the mean height of an American male is 69.3 inches and the mean height of an American female is 63.8 inches. The standard deviation for both genders is 2.7 inches. •According to Chebyshev’s Theorem 75% of the data for your gender lies between what two heights? •If height is assumed to be normal, what percentage of the data lies between those same two heights?
Solved by I. F. in 27 mins
1. departments use exams as part of their promotion process where officers have to score higher than 80% of those taking the exam to be considered for promotion. (This is a z-score of 0.83 or above). Two officers write their exams. officer #1 receives a grade of 70 and officer #2 receives a grade of 72. Note that the mean (of all officers taking the exam is) is 62 and the standard deviation is 11. (20pts) a. Calculate the z-score for officer #1. Was this score high enough to be considered for promotion? b. Calculate the z-score for officer #2. Was this score high enough to be considered for promotion?
Solved by Z. Y. in 13 mins
What does this formula mean ? Thank you =SUMIFS(#REF!,#REF!, ">="&G$13,#REF!, "<="&G$14)
Solved by T. E. in 19 mins