Excel feckwittery

Dave The Iron Ex- Spartan

anyone old enough to remember SuperCalc 5, If you are you would never complain about Excel again 

[Deleted User]

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

Ultra Saffy

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

Nessie

Supercalc.

Ah yes.

I couldn't live without "undo" now.

M..o.use

So...

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

Please.

Johnny Blaze

I like Excel. But i hate Word with a passion.

Alan W

Yay an excel thread - I love Excel

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

M..o.use

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

Thank you.

Alan W

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

[Deleted User]

Proprietary rubish, hate excel with a passion

M..o.use

Hurrah!

Thank you Alan.

Alan W

My pleasure - did I say that I love Excel?

M..o.use

You may have.

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

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

Unknown

Or use

 =A1^0.5

[Deleted User]

i like excel, and look forward to my advanced course next month

Catalin Bond

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?

[Deleted User]

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.

[Deleted User]

Linked spreadsheets? Hmmmmm. Just don't rename or move either of them!