The NOT function, one of many EXCEL logical functions, is used to evaluate a single logical condition, passed as an argument to the function. It will return the opposite of that argument. I.e.:
If the evaluated logical condition is TRUE, the function will return FALSE.
If the evaluated logical condition is FALSE the function will return TRUE.
Syntax
NOT(logical)
Logical is [...]
The IF function, one of many EXCEL logical functions, is used to evaluate a logical condition, passed as an argument to the function. The function will then return one of two values specified as the second argument or the third argument in the function. It will return the second argument if the test evaluates to [...]
To insert the current date in worksheet footer, follow these steps:
1. In the File menu click Page Setup. The Page Setup window will open.
2. Select the Header/Footer tab.
3. Click the Custom Footer button. The Footer window will open.
As you can notice the footer is divided into three sections; left, center and right. Above those sections there is a [...]
If you want to preview a workbook in Windows Explorer without opening it, then you have to save the workbook with a preview picture.
This is how you do it:
In the File menu click Properties. The Properties window will open.
Click on [...]
Excel has a function to generate random numbers: RAND (), and if you have the Analysis ToolPak add-in installed you will have another function available which is RANDBETWEEN().
However both functions will generate one random number. What if you want to generate a list of random numbers? The immediate answer will be: use Autofill.
This is OK [...]
The Microsoft Office Clipboard allows you to collect text and graphic items from any number of Office documents or other programs and then paste them into any Office document. Examples are Microsoft Excel, Microsoft Word and Microsoft PowerPoint.
To use the Office Clipboard you must open it in the task pane of an Office program.
On the [...]
Select the cells for which you want to add conditional formatting.
On the Format menu, click Conditional Formatting.
The Conditional Formatting dialogue will open.
In the first combo box select Formula is.
In the text box next to it [...]
1. Select the cell which you have already formatted.
2. Click Format Painter in the standard toolbar.
3. Click the cell on which you want to apply the format. The format of the first cell will be applied to the new [...]
Click Tools then click Customize .The Customize window will open.
Click the Toolbars tab.
Click New. The New Toolbar window will open.
Enter a name for your toolbar then press OK. This will [...]
If you have a worksheet and you only want to print part of that worksheet then follow the steps below:
Method 1
Click File then click Page Setup .The Page Setup window will open.
Click the Sheet tab.
In [...]
