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

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

wHAT DOES THIS FORMULA MEAN I AM LOOKING FOR A PLAVE TO INPUT SOME NUMBERS INOT MY SPREADSHEET AND THE THIS FORMEUL IS TAKING ME THERE BUT I DO NOT KNOW WHAT IT MEANS

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