Welcome to My Office Power

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…

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