Auto Calculate Formulae

[joecrabtree]

To all,

I need some help with calculating a formula:

In one sheet I have an series of averages ( A2:A, sheet1) -

In another sheet I have a series of standard deviations (A2:A, sheet2)



In a sheet called "calulation" - I want to be able to do the following

In column B:2 - Calulate = (average - 777)/Standard deviation

and then calculate this formula down the column, and to stop when there
is no standard deviations or averages in the relevant rows in the other
sheet1 and sheet2.
Any help would be appreciated.

Thanks in advance,

Regards

Joseph Crabtree

 

[=?iso-8859-8-i?B?7uno7A==?=]

joecrabtree ëúá:

 

[joecrabtree]

Sorry I forgot to say - I need a MAcro to calculate this.

Thanks