TEXT worksheet function

To change only a selected range of values to "precision as displayed", use the FIXED worksheet function (see "Text Fimctions" in Chapter 3). 

Appendix A lists selected worksheet functions in the Database, Date Time, Information, Logical, Lookup Reference, Math Trig, Statistical, Lookup Reference, and Text categories. Appendix B provides an alphabetical list of these worksheet functions along with the required syntax, some comments on the required and optional arguments, one or more examples and a list of related functions. 

The following worksheet functions operate on the date serial value to return a date or time YEAR(value), MONTH(va/ue) and DAY value). Value canhe a serial value, a cell reference or a date as text. MONTH returns a number between 1 and 12, DAY a number between 1 and 31. The text function TEXT can also be used to format a date serial value any custom date format can be applied (see "The FIXED and TEXT Functions" later in this chapter). 

Excel provides a wide range of worksheet functions that operate on text. You are already familiar with the operator, to concatenate text or text and values. Most of Excel s text functions select or modify one or more characters within a text string. 

NAME is displayed when you use a name that Excel doesn t recognize. Most often this occurs when you misspell a name or function, or when you enter a name without having defined it. It will also happen when you enter a text argument in a formula and forget to enclose the text in quotes, or when you use a worksheet function in a formula and forget to include the parentheses and/or arguments. 

The text argument of the indirect worksheet function evaluates to "1 20", and the expression ROW(INDIRECT("1 " A1)) evaluates to... 

Excel 2000 provides more than 300 worksheet functions, in 11 categories Engineering, Financial, Date Time, Information, Math Trig, Statistical, Lookup Reference, Database, Text, Logical, External. This book uses functions from seven of those categories. This appendix lists selected worksheet functions by category. In Appendix B, the functions are listed alphabetically, with comments, examples and related functions. 

Select all the text in the file and COPY/PASTE into cell A 3 of a new worksheet, figl-9.xls. With luck, the EXCEL software will parse the pasted information into columns A and B of the worksheet. If not, open the TOOLS dropdown on the EXCEL toolbar and select the TEXT to COLUMNS option. Follow the wizard s instructions and the radial mesh data will separate in column A from the numerical wave function data, which will appear in column B. 

The program uses the input value of concentration and relative flow times to calculate a molecular weight according to Equations 10.17 and 10.9. This value is used to calculate a zero shear viscosity, and average values for the other parameters of the HN model discussed in the text are adopted to calculate the frequency dependence (i.e., to calculate the viscoelastic moduli as a function of shear rate). All the values adopted in the model are disclosed on the worksheet page. 

One of the reasons why Mathcad has become popular is that a user can insert operators or functions into a worksheets depending which he may have got accustomed to when learning mathematics in school. This makes the Mathcad worksheet looks like a technical paper with calculations made by hand or in a text processor environment (Scientific Word, ChiWriter, etc.). 

You can see the example of work with the function entered through the Text box at http //twt.mpei.ac.ru/mas/worksheets/F X Y Plot.mcd. 

The Reader may want to use ideas of the authors on entering the formula through the Text box. For that, download the file Y X Plot.mcd from Internet description of MAS at http //twt.mpei.ac.ru/ochkovA PU Book New/mas/From WorkSheet to WebSheet.html and enter required changes into two functions VARS and Eval shown in Figs. 6.107 and 6.108. 

---