The formula result is 76% but the cell shows 0%. Why?

S

SteveB

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!
 
S

Stefi

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

Regards,
Stefi

„SteveB†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula result showing 0 3
Result shows correct answer but cell shows 0 1
Formula text in woorksheet cell 2
#DIV/0! in variance/percentage formula 3
Can i avoid "00.00" when the result of a calculation is 0? 4
hyperlink to cell based on formula results 4
one cell in my worksheet appears blank, but answr shows in formula 6
Lookup function did not show the result but.. 2

Top