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