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 > > When the denominator, or Events, =0, I want "Average Score per Event" to be > either blank or zero. > Please, how do I do this??? > > Thank you, > John Gilchrist > Tulsa, OK In the cell where you want the result put
=IF(C2=0;0;C1/C2) Division by zero is impossible so catch it before it happens. See the help pages for the IF function. -- It is often safer to be in chains than to be free. Joseph K --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
