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