| |
06-04-2008, 06:30 PM
| |||
| |||
| 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!      |
|
06-04-2008, 06:30 PM
| ||
| |
|
06-05-2008, 02:20 AM
| |||
| |||
| Re: complicated formula 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! |
 |
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to Convert Sum Text to Formula | Ron Mantle | Microsoft Office | 3 | 11-09-2009 11:12 AM |
| Thumbnails problem, or more complicated? | Swordlord | Windows XP | 0 | 07-15-2007 02:10 AM |
| It's jusst too d--- complicated | Chester GS | Windows Vista | 81 | 06-23-2007 03:50 PM |
| Complicated Request | Michael | Microsoft Office | 4 | 03-22-2007 06:00 AM |
| complicated | awlw1 | Windows XP | 3 | 02-26-2007 09:45 PM |
| New To Technology Questions? | Do You Need Help with Your Computer or Device? | Do You Need Help with this site? |
