Excel 2007 Formulae Qestion

Swordfish · 10 Sep 2008 at 16:56

I have a small table which lists the following

Name, Played, Won, Lost, % Average

Now if when doing my calcualtion the player has played 5 game and won none then the average is 0. Excel insists in giving me #DIV/0 error. The formulae I'm using is

=IF(played/won=0,0,played/won)

What i want it to return is

played 1, won 1 =100

played 1 won 0 = 0

Sorry if this is not too clear, any ideas?

Cheers

mark66 · 10 Sep 2008 at 17:05

Hi,

You need to use ISERROR with an additional IF to state what to do if in error and what to do if good.

So if A1 (played) = 5
And B1 (Won) = 0
Then in C1 type the formula: =IF(ISERROR(A1/B1),0,A1/B1)

Swordfish · 10 Sep 2008 at 17:27

Tried this and now all i get is 0

Even is the player has won all their games the % still shows 0

Here is ascreenshot

Does that help?

Swordfish · 10 Sep 2008 at 17:30

Just solve my own prolbem wwas using the wrong cells for the data. Numpty.

Cheers for this one tho.

Swordfish · 10 Sep 2008 at 17:43

Me again, got all that working. Cheers.

Now I'm trying to get the averave % for a player.

This Screenshot explains better.

Can you help on this one

Swordfish · 10 Sep 2008 at 17:57

Me yet again.....

Used your orignal fix with a bit of arithmetic and got this going. Cheers for this.