Circular Reference error

[mgoldie1]

I've almost gotten this complete. For some reason I get a circular reference error C8 every time I put a negative number in. Can someone help me? Thanks.

Marc

https://www.dropbox.com/s/rs6n3iqjrhvf3ks/Arb Spreadsheet 2.xlsx?dl=0

 

[Fluff]

If D8 is less than 2
E8 is dividing F8 by C8
but F8 is dividing E8 by C8
hence the circular ref

 

[mgoldie1]

If D8 is less than 2
E8 is dividing F8 by C8
but F8 is dividing E8 by C8
hence the circular ref

Thanks Fluff. Any suggestion on how to correct this?

 

[Fluff]

Without knowing what you are trying to do, no.

 

[mgoldie1]

Sorry, that would help to know what I'm trying to do

Trying to find out what I would need to bet (E8) based on the original bet (E7) and odds (C7) and the new odds (C8) to have an equal profit on either side (G7 and G8). Do you understand?

 

[Fluff]

Fraid not, I don't understand that system of odds and don't bet.