Find percentage ???
Er,like =A1*A2 ?????
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email <JoAnne wrote in message ... How do I find percentage of a number... say.. A1 = 100 A2= 60% of A1 (100) Thanks |
Find percentage ???
Divide 1 Cell by the other and then apply the % format to the cell. Example (without the format % applied 100 75 0.75 with the format % applied 100 75 75.00% then in format set how many decimal places you want. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.hightechtalks.com/m390 View this thread: http://www.hightechtalks.com/t2306229 |
All times are GMT +1. The time now is 10:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com