ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Secant function (https://www.excelbanter.com/excel-worksheet-functions/97952-secant-function.html)

PrincipalSealEngineer

Secant function
 
Does anyone have a function to calculate secants in excel. Ref
http://mathworld.wolfram.com/SecantMethod.html

Harlan Grove

Secant function
 
PrincipalSealEngineer wrote...
Does anyone have a function to calculate secants in excel. Ref
http://mathworld.wolfram.com/SecantMethod.html


If you mean finding zeroes of functions, use Solver.


JLatham

Secant function
 
I'm definitely no mathematician, but wouldn't the Excel SEC() function do the
job?
http://support.microsoft.com/?kbid=213887

if this turns out to be totally off base for your needs, be gentle, I said I
wasn't a mathematician.

"PrincipalSealEngineer" wrote:

Does anyone have a function to calculate secants in excel. Ref
http://mathworld.wolfram.com/SecantMethod.html



All times are GMT +1. The time now is 07:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com