complicated formula

D

danfyans

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula 1
Creating Averages for unequal numbers of events 2
Cumulative formula for word table 0
Calculate the median value before a specified list 0
Help with formula 0
need help :D 15
Excel 2010 not allowing me to paste as formula 8
trouble with (complicated) vlookup searching another workbook 2

Top