#1   Report Post  
HELP
 
Posts: n/a
Default 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
  #2   Report Post  
sebastienm
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is the answer to my formula double what it should be? Hayley B Excel Discussion (Misc queries) 1 July 19th 05 11:05 AM
i cant get the exact answer e.g answer is 13.49% i got 13.00% zai Excel Discussion (Misc queries) 3 June 9th 05 01:00 PM
Excel Answer Wizard BROKEN Mark Diaz Excel Discussion (Misc queries) 1 March 11th 05 10:19 PM
Display answer only in another cell of one containing a formula Mally Excel Discussion (Misc queries) 5 January 21st 05 01:07 PM
coverting answer from Radian mode to degree mode Xmastrzman Excel Worksheet Functions 1 November 10th 04 04:45 PM


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"