Excel feckwittery

thank you!

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

Supercalc.

Ah yes.

I couldn't live without "undo" now.

So...

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

Please.

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?

Thank you.

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

Hurrah!

Thank you Alan.

You may have.

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

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

Or use

 =A1^0.5

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.