Re: [users] Calc - Format Error when Denominator = 0

2007-10-21 Thread Joseph
On 13:07 Sun 21 Oct , John Gilchrist wrote: > Dear OOo Users, > > In Calc: > Score is defined as a cell, C1 > Events is defined as a cell, C2 > > I calculate "Average Score per Event" =Score/Events > > This works well until Events = 0. > Then, this expression blows up. >Err:503

[users] Calc - Format Error when Denominator = 0

2007-10-21 Thread John Gilchrist
Dear OOo Users, In Calc: Score is defined as a cell, C1 Events is defined as a cell, C2 I calculate "Average Score per Event" =Score/Events This works well until Events = 0. Then, this expression blows up. Err:503 When the denominator, or Events, =0, I want "Average Score per Even