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.

How to use if statements in Excel

What Does It Do?

This function tests a condition.

If the condition is met it is considered to be TRUE.

If the condition is not met it is considered as FALSE. Depending upon the result, one of two actions will be carried out.

Syntax

=IF(Condition,ActionIfTrue,ActionIfFalse)

The Condition is usually a test of two cells, such as A1=A2.

The ActionIfTrue and ActionIfFalse can be numbers, text or calculations.

Formatting

No special formatting is required.

Example 1

The following table shows the Sales figures and Targets for sales reps.

Each has their own target which they must reach.

The =IF() function is used to compare the Sales with the Target.

If the Sales are greater than or equal to the Target the result of Achieved is shown.

If the Sales do not reach the target the result of Not Achieved is shown.

Note that the text used in the =IF() function needs to be placed in double quotes "Achieved".

Example 2

The following table is similar to that in Example 1. This time the Commission to be paid to the sales rep is calculated. If the Sales are greater than or equal to the Target, the Commission is 10% of Sales. If the Sales do not reach Target, the Commission is only 5% of Sales.

Example 3

This example uses the =AND() within the =IF() function.

A builders merchant gives 10% discount on certain product lines.

The discount is only given on products which are on Special Offer, when the Order Value is £1000 or above.

The =AND() function is used with the =IF() to check that the product is on offer and that the value of the order is above £1000.