Windows Virus on iPods
Apple reported today that some versions of iPods (and here) manufactured on September 12th inadvertently went out with a Windows virus. From the sounds of it, you should be fine if your virus definition files are up-to-date.
Referencing the value of a cell, not its formula
In Excel, I will use formulas quite frequently for my analysis. At times I want to reference the resulting value of the formula for comparison or to feed another formula. Unfortunately, if you are doing a comparison, Excel will try to compare the formula instead of the formulas results. Well, turns out there is an easy way to correct this.
If you want your formula result to be a number, then use the VALUE function. If you want the formula result to be text, use the TEXT function.
Here is the syntax for each:
VALUE(text)TEXT(value,format_text) -- The format_text value can be any format from the Category box on the Number tab (in the Format Cells dialog box) except General.
Here is an example of each:
=VALUE(MID(A2,46,FIND("&",A2)-46)) -- this actually finds a number beginning with the 46th character of a string, and continues until it finds the ampersand character. By wrapping the formula with VALUE, I can now compare the number to other numbers in my lookup table.=TEXT(IF…
If you want your formula result to be a number, then use the VALUE function. If you want the formula result to be text, use the TEXT function.
Here is the syntax for each:
VALUE(text)TEXT(value,format_text) -- The format_text value can be any format from the Category box on the Number tab (in the Format Cells dialog box) except General.
Here is an example of each:
=VALUE(MID(A2,46,FIND("&",A2)-46)) -- this actually finds a number beginning with the 46th character of a string, and continues until it finds the ampersand character. By wrapping the formula with VALUE, I can now compare the number to other numbers in my lookup table.=TEXT(IF…
Comments