Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
scandanavian_haven
24 Jun 11 20:19
Joined:
Date Joined: 27 May 11
| Topic/replies: 17,249 | Blogger: scandanavian_haven's blog
How do you multiply/divide and take away using Excel, I'm trying build a spreadsheet analysing some data from the sports markets here but never really used Excel before.

So you click on a cell, input a number - and then I'm lostLaugh

Adding is straight forward using the 'sum' function but more importantly I can't work out how to Multiply?

Any Excel boffins here? all help appreciated for an Excel dummy.Happy

cheers
Pause • Switch to Standard View using functions in spreadhseet help
Show More
Loading...
Report top2rated • June 24, 2011 9:21 PM BST
For multiplication use the * symbol, for division use the / symbol.  For example......

            A        B        C   
    1        5        10        =A1*B1   
    2        50        10        =A1/B1   
Report top2rated • June 24, 2011 9:23 PM BST
Whoops.

Make that.....

            A        B        C   
    1        5        10        =A1*B1   
    2        50        10        =A2/B2   


Happy
Report Rocket to the FACE • June 24, 2011 9:23 PM BST
Remember the '=' sign, very easy to forget.
Report scandanavian_haven • June 24, 2011 9:36 PM BST
Top2rated you really should get a subscription service going[;)] top man,  I used to work as a Youth Leader so MS Office Applications wre never of use - except Word.

Also, I'm going to try and work out how you've somehow managed to Turn your image upside downLaugh

Very true Rocket too, thanks.
Report theonlywayforward • June 25, 2011 12:15 AM BST
http://office.microsoft.com/en-gb/excel-help/audio-course-get-to-know-excel-...
Report FINE AS FROG HAIR • June 25, 2011 1:09 AM BST
Scandy
Don't you know any kids ?
They'll all be wizards at all this .
Report scandanavian_haven • June 25, 2011 11:58 AM BST
theonlywayforward - Top stuff! cheers mate.


Yes Froggy. but it's much quicker, easier, if I just post a question rather then ringing someone up, sounding like a fool, and hearing them trying to explain the answer.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com