Installed function

You can now use this newly created function in any spreadsheet, new or old, it does not matter. For example, I open the file with the invoice that I had made earlier and add a column (1) in order to calculate the rebate.

I select the cell where the discount should be shown (2) and click the “Insert Function” button in the formula bar (3).

This opens the “Insert Function” where I select the function (1). If you do not find it, select “All” (2) In the “Select a category “, then it will be listed.

Click the OK button.

This opens the “function arguments” window of the newly installed function.

Select the cell where the number is, select the cell where the price is and fill-in boxes for both by clicking the hiding buttons (1 and 2).

Click the OK button when you’re done.

The rebate is calculated as shown in the figure below, from the number 100 or higher (1). If the number is less, then you do not get discount (2).

You can copy this function to the underlying cells because the cell reference in the formula is not “absolute” but “relative”.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats