MrExcel.com - Your One Stop for Excel Tips & Solutions

excel formula

Posted by Rene Bouman on May 10, 2001 7:08 PM

I need to find the 90% of a number of figures continously. There are formulas for 50%, median and average.
Can you help please.
rene

Posted by Kevin James on May 10, 2001 7:38 PM

Hi rene

any number * .9 is 90%.

If A1 contains 100 and B1 contains the formula:
=A1*.9
the answer will be 90

Kevin