ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW TO GET AN ANSWER (https://www.excelbanter.com/excel-discussion-misc-queries/41756-how-get-answer.html)

HELP

HOW TO GET AN ANSWER
 
HOW TO GET AN ANSWER WHEN YOU ADD 1+2+3+4=? THEN DIVIDE BY 4 BECAUSE THERE
IS ONLY 4 NUMBERS= ?

YOU GET TO ADD ALL YOUR NUMBERS AND THEN GET AN ANSWER AND YOU DIVIDE BY
THE TOTAL OF NUMERATORS IN YOUR EQUATION AND THEN DIVIDE AND THAT EQUALS THE
NUMBER

sebastienm

Hi,
Seems like you are trying to compute an average.
Assuming your numbers are in cells A1, A2, A3, and A4, ie the range A1:A4,
then in a cell enter the formula:
= AVERAGE(A1:A4)

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"HELP" wrote:

HOW TO GET AN ANSWER WHEN YOU ADD 1+2+3+4=? THEN DIVIDE BY 4 BECAUSE THERE
IS ONLY 4 NUMBERS= ?

YOU GET TO ADD ALL YOUR NUMBERS AND THEN GET AN ANSWER AND YOU DIVIDE BY
THE TOTAL OF NUMERATORS IN YOUR EQUATION AND THEN DIVIDE AND THAT EQUALS THE
NUMBER



All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com