Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COS H (Trigonometry)
I need to use the funtion COSH squared or COSH ^2 in a cell to calculate an
answer. How can this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COS H (Trigonometry)
"Shortstopper00" wrote:
I need to use the funtion COSH squared or COSH ^2 in a cell to calculate an answer. How can this be done? You almost wrote the answer yourself: =COSH(A1)^2 I suspect there is more behind your simplistic question. If you need more help, provide more details. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COS H (Trigonometry)
Shortstopper00 wrote:
I need to use the funtion COSH squared or COSH ^2 in a cell to calculate an answer. How can this be done? Does this do what you want? =POWER(COSH(A1),2) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COS H (Trigonometry)
I would think this should do it...
=COSH(A1)^2 If you are going to make it part of a longer calculation, then you might want to enclose it in parentheses to make it clear what is going on.... =3*(COSH(A1)^2)+4 -- Rick (MVP - Excel) "Shortstopper00" wrote in message ... I need to use the funtion COSH squared or COSH ^2 in a cell to calculate an answer. How can this be done? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COS H (Trigonometry)
I don't know which half of the problem is causing you difficulty.
To take the COSH of A1, the formula is =COSH(A1) To take the square of B1 the function is =B1^2 So to take the square of the COSH of A1 the function is =COSH(A1)^2 -- David Biddulph "Shortstopper00" wrote in message ... I need to use the funtion COSH squared or COSH ^2 in a cell to calculate an answer. How can this be done? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COS H (Trigonometry)
Since XL uses parenthesis to in-close functions, you would write it:
=COSH(A1)^2 Note that this is different than =COSH(A1^2) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Shortstopper00" wrote: I need to use the funtion COSH squared or COSH ^2 in a cell to calculate an answer. How can this be done? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COS H (Trigonometry)
=COSH(A1)^2
"Shortstopper00" wrote: I need to use the funtion COSH squared or COSH ^2 in a cell to calculate an answer. How can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trigonometry in Excel | Excel Discussion (Misc queries) | |||
Trigonometry in Excel | Excel Discussion (Misc queries) | |||
Trigonometry & Math functiona in Excel | Excel Discussion (Misc queries) | |||
Trigonometry with excel | New Users to Excel | |||
Trigonometry | Excel Discussion (Misc queries) |