IIF, still returning #error

[Cheveliar]

I have written the following IIF statement:

IIf([Wins]/([Wins]+[Losses])=0,0,([Wins]/([Wins]+[Losses])))

The reason I wrote it this way because I have fields that would give me a 0/0 scenario. I'd like to account for this and return a 0 in that instance. Is there a way to do this or am I doomed to get the #error?

 

[KenReay]

Hi

It is division by zero you must avoid, so should it be:



IIf([Wins]+[Losses]=0,0,([Wins]/([Wins]+[Losses])))



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Cheveliar]

Thanks that was it!!!