corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » quick excel/maths help!


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author quick excel/maths help!
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
24th Jul 07 at 15:24   View Garage View User's Profile U2U Member Reply With Quote
Im trying to write the formula to work out the percentage profit i am in playing poker in a spread sheet.

i started with £100

in cell D1 i have my current bankroll

how do i put it so it shows the % profit or loss?

CHeers

Adult GiftsClick here to vist us
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
24th Jul 07 at 15:32   View User's Profile U2U Member Reply With Quote
So you want to know

£100 start, D1

What D1 is as a % to your starting share

I wouldnt know how to do that, say D1 = 1000, 100 start, 1000 bankroll = 10x profit

as a % i dunno, D1/100*?
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
24th Jul 07 at 15:32   View User's Profile U2U Member Reply With Quote
Ive confused myself even more
M4tt_Envoy
Member
Registered: 26th Feb 06
Location: Swindon
User status: Offline
24th Jul 07 at 15:34   View User's Profile U2U Member Reply With Quote
new amount\D1 *100
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
24th Jul 07 at 15:35   View User's Profile U2U Member Reply With Quote
Are you including your £100 stake as winnings or taking it off your winnings?
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
24th Jul 07 at 15:35   View Garage View User's Profile U2U Member Reply With Quote
yes ally 100 to 1000 would b 10x my start, which is 900% profit is it not?

Adult GiftsClick here to vist us
M4tt_Envoy
Member
Registered: 26th Feb 06
Location: Swindon
User status: Offline
24th Jul 07 at 15:35   View User's Profile U2U Member Reply With Quote
bearing in mind if you using £100, the new amount will always be the profit gained/lost
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
24th Jul 07 at 15:36   View User's Profile U2U Member Reply With Quote
bankroll = E1

(E1-D1)\D1*100
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
24th Jul 07 at 15:37   View User's Profile U2U Member Reply With Quote
ffs, ill shut up now
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
24th Jul 07 at 15:37   View Garage View User's Profile U2U Member Reply With Quote
matt, that wont work cos d1 is my new amount

basically i have 100 at start, and d1 is my current balance. so if it was 200 in d1, it should say 100% profit. 100 in d1 being 0% profit

Adult GiftsClick here to vist us
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
24th Jul 07 at 15:38   View User's Profile U2U Member Reply With Quote
1000-100(900)/100=(9)x100 = 900

Im such an idiot
M4tt_Envoy
Member
Registered: 26th Feb 06
Location: Swindon
User status: Offline
24th Jul 07 at 15:41   View User's Profile U2U Member Reply With Quote
use 4 cells

stake (100)
balance (1000)
profit in £'s (900)(f1) =d1-e1
percentage (900%) = f1/d1*100
Dan
Premium Member

Avatar

Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
24th Jul 07 at 15:47   View Garage View User's Profile U2U Member Reply With Quote
job done, just did =((d1-100)/100)

then made the cell a percentage format

Thanks

Adult GiftsClick here to vist us

 
New Topic
New Poll

Corsa Sport » Message Board » Off Day » quick excel/maths help! 25 database queries in 0.0155840 seconds