complicated formula

Hi, I am doing a cricket stat sheet on excel and need a formula for batting
averages, but if the batsman is not out, then you only divide his total runs
by the NUMBER OF TIMES he has got out. so is there anyway to tell excel to
divide this but with some execptions if the batter is not out?

sorry if it is not that clear! Thanks!

You might find something here, there are Excel downloads for Cricket. Terrible
web site but the download links seem to work okay.
http://www.cricketweb.net/downloadsc...cellaneous.php

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"danfyans" <danfyans@discussions.microsoft.com> wrote in message
news:E2C9CD00-90BF-4516-9416-FD80F189350E@microsoft.com...
> Hi, I am doing a cricket stat sheet on excel and need a formula for batting
> averages, but if the batsman is not out, then you only divide his total runs
> by the NUMBER OF TIMES he has got out. so is there anyway to tell excel to
> divide this but with some execptions if the batter is not out?
>
> sorry if it is not that clear! Thanks!