Please help or I may just tear all my hair out
The name rings a bell. The first spreadsheet I used was Quattro Pro at Uni - I remember buying a copy and installing it from floppy. Think it was an early Windows version.
I never complain about Excel anyway. (Okay, maybe I do, but not as much as I do about Word).
Dave The Ex- Spartan wrote (see)
anyone old enough to remember SuperCalc 5, If you are you would never complain about Excel again
OMG yes !!! I remember some very garish colours and having to hit the / key a lot to get it to do anything.........but at the time it seemed really cool .
It was my first venture into the exciting world of spreadsheets
I couldn't live without "undo" now.
I want column A to contain numbers I input. I want column B to automatically calculate the square root of column A.
Yay an excel thread - I love Excel
M.ouse - to calculate square root of A1 in cell B1 enter =SQRT(A1)
and then can I copy the formula down? I sort of drag it don't I?
If you want it to do it automatically then enter this into B1 and drag down however many rows you want
When you enter a value in A then the square root will automatically appear in B otherwise it will be blank
Thank you Alan.
You may have.
It's ok, you're among friends here.
(apart from me, I'm rubbish at it)
Boinging this thread as I can't find the geeks thread. I learnt something new on excel this morning and I didn't stop grinning for 3 hours.
I've got 2 spreadsheets, relating to supplier prices. I input the price in one, and if it's changed since the last invoice, copy it into the other for each department that has that product. eg, If coke has changed from 19p a can to 21p, I change it in Suppliers, then in each of 13 departments in Stocktake.
I got shown how to do a link paste so when I change it in Suppliers, it automatically changes in each department on Stocktake.
Visit the official Runner's World page
Follow Runner's World on Twitter
Other Natmag-Rodale Sites
Run For Charity
About Runner's World
Runner's World is a publication of Hearst Magazines UK which is the trading name of The National Magazine Company Ltd, 72 Broadwick Street, London, W1F 9EP. Registered in England 112955. All rights reserved.
Website powered by: Immediate Media Company Ltd. | © Runner's World 2002-2014 |