Excel feckwittery

Please help or I may just tear all my hair out

61 to 79 of 79 messages
14/07/2010 at 13:28

thank you!

14/07/2010 at 13:30
anyone old enough to remember SuperCalc 5, If you are you would never complain about Excel again 
Edited: 14/07/2010 at 13:30
15/07/2010 at 12:42

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).

15/07/2010 at 21:04
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

16/07/2010 at 15:52

Supercalc.

Ah yes.

I couldn't live without "undo" now.

23/07/2010 at 16:56

So...

I want column A to contain numbers I input.  I want column B to automatically calculate the square root of column A.

Please.

23/07/2010 at 17:06
I like Excel. But i hate Word with a passion.
Alan W    pirate
23/07/2010 at 17:10

Yay an excel thread - I love Excel

M.ouse - to calculate  square root of A1 in cell B1 enter =SQRT(A1)

23/07/2010 at 17:13

and then can I copy the formula down?  I sort of drag it don't I?

Thank you.

Alan W    pirate
23/07/2010 at 17:13

If you want it to do it automatically then enter this into B1 and drag down however many rows you want

=IF(A1="","",SQRT(A1))

When you enter a value in A then the square root will automatically appear in B otherwise it will be blank

Edited: 23/07/2010 at 17:14
23/07/2010 at 17:16
Proprietary rubish, hate excel with a passion
23/07/2010 at 17:16

Hurrah!

Thank you Alan.

Alan W    pirate
23/07/2010 at 17:21
My pleasure - did I say that I love Excel?
23/07/2010 at 17:29

You may have.

It's ok, you're among friends here.

(apart from me, I'm rubbish at it)

23/07/2010 at 18:09

Or use

 =A1^0.5

23/07/2010 at 19:47
i like excel, and look forward to my advanced course next month
30/07/2010 at 14:55
Hope you don't mind another excel question. I have a database with multiple sheets, and each sheet has data organised in the same way. I was to collect all that data into one spreadsheet by taking the values from each sheet and putting them into a column. Is there any way of doing this that is quicker than cutting and pasting?
30/09/2010 at 22:09

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.

02/10/2010 at 18:44
Linked spreadsheets? Hmmmmm. Just don't rename or move either of them!

We'd love you to add a comment! Please login or take half a minute to register as a free member
61 to 79 of 79 messages
Previously bookmarked threads are now visible in "Followed Threads". You can also manage notifications on these threads from the "Forum Settings" section of your profile settings page to prevent being sent an email when a reply is made.
Forum Jump  

RW Forums