PDA

View Full Version : Solved: Excel Division



Slicemahn
02-03-2009, 10:30 AM
I have never come across this before.. I have two columns in which I perform array formulas to obtain counts. When I use the formula

=if(iserror($d3/sum($d3,$e3)),"-",$d3/sum($d3,$e3))

for cells d3=15 e3=37

I get an answer of 0?

When this formula is copied down, some cells populate correctly and others do not.

Any ideas of why this has happened?

Bob Phillips
02-03-2009, 11:47 AM
Works fine for me. What calculation mode are you set at?

Slicemahn
02-04-2009, 07:01 PM
My calculation mode is automatic... however, in checking the formulas... I believe I could have included a row of cells as one array formula.....

Bob Phillips
02-05-2009, 03:07 AM
Well, get back if you still have the problem, maybe post the workbook.

mikerickson
02-05-2009, 07:19 AM
Is the cell formatting showing a fraction as 0?