liability with excel

[vulturesquad]

hi all,

First post here basically i have a field that is set to work out the correct stake based on liability referencing 2 cells.
So A1/(A2-1) gives my stake and this is on a seperate worksheet.

The problem is when Gruss tells excel to copy the information it is placing the stake in the S cells as a minus figure is there anyway to correct this

[alrodopial]

=abs(value)

gives the absolute value

[vulturesquad]

no the above suggestion doesnt work.
round works with my odds but when i try and use liability and use triggers like on the Multiple Triggers download sheet the correct liability is shown in cell triggers c2 but when copied over gives everything but the correct stake.

[vulturesquad]

i get #div/0! when the stake is copied over

[MarkRussell]

i get #div/0! when the stake is copied over

Hi,

If you want to email me a copy of your sheet where you are getting #div/0!. I will take a look to see if I can correct it for you.

Email to admin@gruss-software.co.uk

Regards,
Mark

[vulturesquad]

awesome mark thank you

i will get it sent over

[vulturesquad]

just like to say a big THANK YOU to MarkRussell for advising what was causing my issue and fixing it for me