Search Msdn

How to use A functions in Excel

Text and logical values are ignored by the MIN and MAX functions. Using the example data in the AVERAGEA and AVERAGE section, consider the following formulas:

Works: Spreadsheet Functions Imported from Excel 2000 to Works

Functions that return a text string have their last return value imported as text. Functions that return decimal numbers have their last return value imported as decimal.

MACXL: How to Change the Case of Text

This article describes how to use worksheet functions to change the case of text.

SUMIF() Function Fails If Sum_Range Contains Links to Text

Any cell in the sum_range that contains a link to text causes this problem when a cell ... Excel 5.0 Samples file in your Excel directory in cells C14:E16 on the Worksheet Functions ...

TEXT(MONTH(NOW()),"mmm") Always Returns "Jan"

When you nest the TEXT(), MONTH(), and NOW() functions as in the following example Microsoft Excel will always return the result "Jan".

XL97: New A Functions in Microsoft Excel 97

Text and logical values are ignored by the MIN and MAX functions. Using the example data in the AVERAGEA and AVERAGE section, consider the following formulas.

XL: How to Reverse the Order of Words in a Text String

This article explains how to reverse the order of words in a comma-separated text string by using the FIND, LEFT, LEN, and RIGHT functions in Excel. Suppose that there are two ...

How to Convert Text to Numbers in Excel

This will cause functions such as SUM() and AVERAGE() to ignore the values in these cells. These text strings may contain actual text in addition to the numbers you want to ...

XL98: Unexpected Results with Mixed Text and Numbers in Lookup Table

After you create a lookup table, you may experience either of the following symptoms: Lookup functions on a worksheet may return the #N/A error value. -or- Lookup functions in a ...

Function to compute average without high and low values

and then double-click the selected text to go to the "About user-defined functions" topic.

XL2000: Sample Macro Code to Change Case of Text

Although Microsoft Excel has functions that change the case of text, there are times when you may want to change text case programmatically. This article contains three sample ...

XL97: ROW And COLUMN Functions Are Not Recalculated

For more information about writing custom functions, click the Index tab in Visual Basic for Applications Help, type the following text

XL98: New A Functions in Microsoft Excel 98 Macintosh Edition

Text and logical values are ignored by the MIN and MAX functions. Using the example data in the AVERAGEA and AVERAGE section, consider the following formulas.

XL97: Page Fault Using Formula Containing Boolean Functions

For more information about using logical functions in formulas, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel 97 Help, type the following text ...

How to Find Secant, Cosecant, or Cotangent of an Angle

and then double-click the selected text to go to the "About math and trigonometry functions" topic. If you are unable to find the information you need, ask the Office Assistant.

XL97: Results Do Not Change After Toggling Transition Formula ...

Earlier versions of Microsoft Excel treat text values that are arguments as zero, FALSE as 0 (zero) and TRUE as 1 (one) for these functions when the Transition Formula Evaluation ...

How to use the left, right, mid, and len functions in Visual Basic for ...

This article contains examples of how to manipulate text strings using the Left, Right, Mid, and Len functions in Microsoft Visual Basic for Applications in Microsoft Excel.

XL2000: TEXT(MONTH(NOW()),"mmm") Always Returns "Jan"

When you nest the TEXT(), MONTH(), and NOW() functions as in the following example =TEXT(MONTH(NOW()),"mmm") Microsoft Excel will always return the result "Jan."

XL98: Results Do Not Change After Toggling Transition Formula ...

The calculation behavior of these functions has changed in Microsoft Excel 98 Macintosh Edition. These functions ignore text values and logical values that are arguments even ...

How to count the occurrences of a number or text in a range in Excel ...

This article explains how you can use worksheet functions in Microsoft Excel for Mac to count the number of occurrences of a specific number or text string in a range of cells on a ...

Differences between the Excel statistical functions STDEVPA and STDEVP

STDEVP ignores blank cells and cells that contain TRUE, FALSE, or a text string. These interpretations also apply for the COUNT, AVERAGE, and STDEV functions.

How to change the case of text in Excel

Describes how to use worksheet functions to modify the case of text in Excel. Provides an example.

XL2000: Calculation of Formula in Formula Bar Returns #VALUE!

... you select the formula in the formula bar and press F9, the formula returns #VALUE! instead of a string that contains 1000 "a" characters as expected. The following text functions ...

#VALUE error when you add text and values in Excel

In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error. Although some functions correctly evaluate ...

Description of the undiscovered tips about Excel

On the Data menu, click Text to Columns. In step 1 in the Text Import Wizard, click ... The formula uses nested IF functions for each cell in the range and adds one to the ...

How to use custom functions with the Spreadsheet component

Create an HTML Page with a Spreadsheet Component that Uses the Custom Functions in the COM Object. Using Notepad, create a new text file that contains the following:

Excel statistical functions: VARA

All functions that are used in cells D3:D10 see the data in A1:A8. VARA treats the text string in cell A1 as the value 0, the numeric values in A3:A7 as numeric values ...

Using INDEX and MATCH Against Multiple Criteria

and then double-click the selected text to go to the "About lookup and reference functions" topic. "User's Guide 1," version 4.0, pages 132, 138

Unexpected Results with Mixed Text and Numbers in Lookup Table

In Microsoft Excel 7.0 and earlier, when you create a lookup table, the lookup functions may return the #N/A error value, or, if you are using the functions in a Microsoft Visual ...

Using Left, Right, Mid and Len in Visual Basic

This article contains examples of how to manipulate text strings using the Left, Right, Mid, and Len functions in Microsoft Visual Basic for Applications in Microsoft Excel.

XL98: How to Find Secant, Cosecant, or Cotangent of an Angle

Microsoft Excel 98 Macintosh Edition has built-in functions for a large number of ... earlier than 8.0), click the Index button in Excel Help, type the following text

Sample macro code to change the case of text in Excel

Although Microsoft Excel has functions that change the case of text, there are times when you may want to change text case programmatically. This article contains three sample ...

Open Method [Excel 2007 Developer Reference]

If the file is a text file and the Format argument is 6, this argument is a string that specifies the character to be used as the delimiter. For example, use Chr(9) for tabs, use ...

Using a Worksheet Function in a Visual Basic Macro

and then double-click the selected text to go to the "List of Worksheet Functions Available to Visual Basic" topic.

Functions Are Not Saved in Lotus 1-2-3 Format

Functions Are Not Saved in Lotus 1-2-3 Format ... Lotus 1-2-3, click the Index tab in Microsoft Excel Help, type the following text

XL: Unexpected Results with Mixed Text and Numbers in Lookup Table

In Microsoft Excel 97 and later, when you create a lookup table, the lookup functions may return the #N/A error value, or, if you are using the functions in a Microsoft Visual ...

ODBC 2.0 Drivers Use the MID() Scalar Function

and then double-click the selected text to go to the "Scalar Functions" topic.

Excel statistical functions: DVAR, DVARP, DSTDEV, and DSTDEVP

The functions take as observations the field values in each database record that ... from its initial value of 0, these values appear in parentheses in the text ...

How to use the LOOKUP function in Excel

... that contains text, numbers, or logical values that you want to compare with lookup_value. The array form of LOOKUP is similar to the HLOOKUP and VLOOKUP functions.

Description of the STDEVA statistical function in Excel

All functions that are used in cells D3:D10 refer to the data in A1:A8. STDEVA treats the text string in cell A1 as the value 0, the numeric values in A3:A7 as numeric values, and ...

Functions Not Saved to Quattro Pro File Format

Functions Not Saved to Quattro Pro File Format ... And Index on the Help menu, click the Index tab in Excel Help, type the following text

Description of limitations of custom functions in Excel

The functions included in Microsoft Excel also cannot change the environment. Functions can perform a calculation that returns either a value or text to the cell that ...

Macro to Determine If a Number Is Even or Odd

For more information about the IsEven and IsOdd functions, click the Index tab in Microsoft Excel 7.0 Help, type the following text

Search Method [Excel 2007 Developer Reference]

Use SEARCH and SEARCHB to determine the location of a character or text string within another text string so that you can use the MID and MIDB or REPLACE and REPLACEB functions to ...

Excel statistical functions: TINV

With the text still selected, use one of the following procedures, as appropriate for ... No modifications were made to the following functions that are called by these inverse ...

Description of ODBC add-in functions and arguments in Excel 2000

Lists functions that are provided by the Xlodbc.xla ODBC add-in. The ODBC add-in lets you ... use to separate the elements in column_delimiter each row of the created text ...

Numbers that are copied from Access 2002 paste as text in Excel 2002

... into Microsoft Excel 2002, the data type of the pasted numbers is text. They data appears as numbers, but sorts as text and are not available for formulas and functions.

Excel statistical functions: LOGINV

With the text still selected, use one of the following procedures, as appropriate ... No modifications were made to the respective functions that are called by these inverse ...

XL97: Calculation of Formula in Formula Bar Returns #VALUE!

... select the formula in the formula bar and press F9, the formula returns #VALUE! instead of a string that contains 1000 "a" characters as expected. The following text functions ...

Calling into Excel from the DLL/XLL

The Excel4 and Excel4v functions are exported by the library xlcall32.lib, which must be ... calling the function FIND even though it evaluated to #VALUE! because the search text ...