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!

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

yes

"Mattlynn via OfficeKB.com" wrote:

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

if you wish, you can email me the speadsheet to look at.


SteveB wrote:
yes

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

[quoted text clipped - 3 lines]
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

Was not the successful example an array formula (enclosed by {...})?

Regards,
Stefi

€žSteveB€� ezt Ã*rta:

yes

"Mattlynn via OfficeKB.com" wrote:

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