Are the cells formatted to %, to 2 decimal places??



SteveB wrote:
I'm trying to show the % of billing is contributed by the top 3 ranked
accounts, so have used a formula which I've used successfully on another
sheet (=SUM(IF(list of ranked data<4,billing amounts,0))/Total Billing). The
cell shows 0% but when I click the fx button it gives the answer as 76%
(which is correct) but it just won't show the result in the cell!

--
Matt Lynn

Message posted via http://www.officekb.com