Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Calculate Formulae
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Calculate Formulae
Sorry I forgot to say - I need a MAcro to calculate this. Thanks On Dec 1, 11:22 am, John Bundy wrote: I may misunderstand, but is this what you need? =((Sheet1!A2-777)/Sheet2!A2) -John "joecrabtree" wrote: 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- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto propagate formulae? | New Users to Excel | |||
Formulae does not re-calculate | Excel Discussion (Misc queries) | |||
formulae to calculate sub totals | Excel Programming | |||
Calculate a Formulae | Excel Discussion (Misc queries) | |||
students grades, formulae to calculate what grade is needed based. | Excel Worksheet Functions |