MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COMBINE 2 FUNCTIONS


Posted by ALBERT on October 21, 2001 11:05 AM

HOW CAN I COMBINE THE AVERAGE FUNCTION TO FIND THE AVERAGE OF A RANGE OF CELLS AND THEN ROUND IT USING THE ROUND FUNCTION?


Posted by Jonathan on October 21, 2001 11:30 AM

Ouch! Why are you shouting, it hurts my ears.

=ROUND(Average(A1:A12),2)

will give the average of the values in A1:A12 rounded to two decimal places.

In general you can NEST as many functions as you like if each returns the kind of information (data-type) that the next one can handle. For a perhaps useless example you could add another function to the above:

=RIGHT(Round(Average(A1:A12),2),2)

would give you just the two right-most digits of your rounded average of the values in a1:a12. I think you can nest up to seven levels as long as you don't go over the 1024 characters per cell limit.

HTH