Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel worksheet function

Is there anyway to see the actual formula that a worksheet function uses?
--
Thanks for your help
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Worksheet Function Rick Excel Worksheet Functions 1 May 11th 06 03:43 AM
excel worksheet function jer130 Excel Worksheet Functions 0 October 8th 05 01:27 AM
excel worksheet function rajkumarthakur Excel Worksheet Functions 1 September 30th 05 08:01 PM
Excel If then Else function in Worksheet rajeevprabhuat Excel Worksheet Functions 2 July 20th 05 06:40 AM
Excel worksheet function Lotus123 Excel Discussion (Misc queries) 1 April 23rd 05 01:09 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"