Even the Microsoft People doesn't Know about this!!

Hi you might have shocked to read this post headline, I really don't know if it is true but of course there is a magic in Ms word which i have not yet heared or seen even on ms site, why it happens in Ms word ?

It is said that, even the Microsoft people don't know about this why and how it happens. Just try it and see the magic. Dont worry by doing this nothing will happen to your

computer nor the Ms word application just do the following

Open Microsoft Word and type

=rand (200, 99)

And then press ENTER

Then see the magic…

Calculate a weighted average

To do this task, use the SUMPRODUCT and SUM functions.
This example calculates the average price paid for a unit across three purchases, where each purchase is for a different number of units at a different price per unit.

	A	B
	Price per unit	Number of units
1	20	500
2	25	750
3	35	200
	Formula	Description (Result)
	=SUMPRODUCT(A2:A4,B2:B4)/SUM(B2:B4)	Divides the total cost of all three orders by the total number of units ordered (24.66)

This post is brought to you from the microsoft website