#DIV0!

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
BLUFFdisko
Posts: 30
Joined: Sun May 17, 2009 11:34 am

Hej guys

Hope someone can help

When i am calculating the book% in this new excel sheet im making, some of the calculatings are showing something like this #DIVO!. i know its because i devide 1 with the given horse, and when i then open up a new market with fewer horses, it devide 1 with 0, and this it aparently cant do.

I need to find a way to go around this as i cant sum up the figures if it shows "DIV0!
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

HI,
This formula will return a 0 instead of the Div error:

=IF(ISERROR(D6/E6),0,D6/E6)

Just change the references to suit.

Hope it helps.
Nigel.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”