How to use ISBLANK function in MS EXCEL?

ISBLANK

What Does It Do?

This function will determine if there is an entry in a particular cell.

It can be used when a  spreadsheet has blank cells which may cause errors, but which will be filled later as the data is received by the user. Usually the function is used in conjunction with the =IF() function which can test the result of the = ISBLANK() Syntax              =ISBLANK(CellToTest) Formatting Used by itself the result will be shown as TRUE or FALSE. Example The following example shows a list of cheques received by a company. When the cheque is cleared the date is entered. Until the Cleared date is entered the Cleared column is blank. While the Cleared column is blank the cheque will still be Outstanding. When the Cleared date is entered the cheque will be shown as Banked. The =ISBLANK() function is used to determine whether the Cleared column is empty or not.

EDATE-Calculate a date which is a specific number of months in the past or in the future

What Does It Do?

This function is used to calculate a date which is a specific number of months in the past or

in the future. Syntax =EDATE(StartDate,Months) Formatting

The result will normally be expressed as a number, this can be formatted to represent
a date by using the Format,Cells,Number,Date command.


Example



This example was used by a company hiring contract staff.
The company needed to know the end date of the employment.
The Start date is entered.
The contract Duration is entered as months.
The =EDATE() function has been used to calculate the end of the contract.

The company decide not to end contracts on Saturday or Sunday.

The =WEEKDAY() function has been used to identify the actaul weekday number of the end date.

If the week day number is 6 or 7, (Sat or Sun), then 5 is subtracted from the =EDATE() to 

ensure the end of contract falls on a Friday.

Use Excel's SUMPRODUCT To Summarize Worksheet Data

SUMPRODUCT

What Does It Do ?

This function uses at least two columns of values. The values in the first column are multipled with the corresponding value in the second column. The total of all the values is the result of the calculation.

Syntax

=SUMPRODUCT(Range1, Range, Range3 through to Range30)

Formatting

No special formatting is needed.

Example

The following table was used by a drinks merchant to keep track of stock.

The merchant needed to know the total purchase value of the stock, and the potential value of the stock when it is sold, takinging into account the markup percentage.

The =SUMPRODUCT() function in Excel is used to multiply the Cases In Stock with the Case Price to calculate what the merchant spent in buying the stock.

The =SUMPRODUCT() function in Excel is used to multiply the Cases In Stock with the Bottles In Case and the Bottle Setting Price, to calculate the potential value of the stock if it is all sold.