Monday, July 26, 2021

You are not logged in.

**MitchBVI****Member**- Registered: 2006-02-14
- Posts: 273

Is there a way to calculate a STDEV in Excel without having to enter the result in an excel cell.

At present the best I can do is

## Applescript:

tell application “Microsoft excel”

Set Formula of cell (“G20”) to “=STDEV.S(G3:G12)”

Set CheckF to value of cell (“G20”)

Set value of cell(“G2-“) to “‘

End tell

Thanks

Offline

**roosterboy****Member**- Registered: 2010-04-19
- Posts: 49

Use the **evaluate** command:

## Applescript:

tell application "Microsoft Excel"

set stdev to evaluate name "=STDEV.S(G3:G12)"

end tell

*Last edited by roosterboy (2021-06-15 10:23:07 pm)*

Offline

**MitchBVI****Member**- Registered: 2006-02-14
- Posts: 273

Brilliant thanks very much, have not been able to find much about " evaluate name" but I assume an AppleScript command that will work with most excel functions.

Peter

Offline