Type in the range of cells you want to select using the following format: First Cell:LastCell. To calculate a random number from a normal curve of potential sales, we need to know the mean and standard deviation of our sales curve. ![]() Cell B1005 you need to set to 33 to achieve the average of 3 (due to rounding differences in between) 3. If you have basic knowledge of the Excel SUM function, the below formula will hardly require any explanation: =SUM (B2*C2, B3*C3, B4*C4, B5*C5, B6*C6,)/SUM (C2:C6) In essence, it performs the same calculation as described above, except that you supply cell references instead of Syntax. ![]() ![]() When using the AVERAGE function in Excel sheets, please do keep in mind the difference between cells containing zero values and blank cells - 0's are counted, but empty cells are not.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |