ExcelBanter

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

Charlie German

Excel worksheet function
 
Is there anyway to see the actual formula that a worksheet function uses?
--
Thanks for your help

Niek Otten

Excel worksheet function
 
Hi Charlie,

In most if not all cases the formula used is listed in Excel Help for that
function
Select the formula, move the cursor to the function call, click the fx
symbol next to the formula bar, click Help on this function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Charlie German" wrote in message
...
Is there anyway to see the actual formula that a worksheet function uses?
--
Thanks for your help



Gord Dibben

Excel worksheet function
 
What do you mean by this?

You can see formulas in the formula bar.

Please elaborate.


Gord Dibben MS Excel MVP

On Thu, 15 Oct 2009 08:40:32 -0700, Charlie German
wrote:

Is there anyway to see the actual formula that a worksheet function uses?



Glenn

Excel worksheet function
 
Charlie German wrote:
Is there anyway to see the actual formula that a worksheet function uses?



Which function are you interested in? The help file lists some of them.


All times are GMT +1. The time now is 08:32 AM.

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