Page 416 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 4 : Computing Total Cost based on Quantity
This example is actually fun to learn. You can apply this theory to other problems as well. Here, in Column B, we
have the Quantity of Unit. And, in Column C, there is their corresponding Unit Price. In essence, we want to know
how much this will cost if we order a certain quantity of units.

From the picture above, we can see that the unit price is decreasing gradually with the increase in order amount.
So, it will cost us less if we order in bulk. Let’s see it in action.
• Initially, go to cell C12 and put the following formula into the cell.
=C11*IF(C11>=101,C9, IF(C11>=51, C8, IF(C11>=21, C7, IF( C11>=11, C6, IF(C11>=1, C5, “”)))))
Formula Breakdown

• IF(C11>=1, C5, ” “) →The IF function checks whether a condition is met, and returns one value if TRUE, and
another one if FALSE. Here, C11>=1 is the logical_test argument which compares the value of the C11 cell
with 1. If this value is greater than or equal to 1 then the function returns the value of cell C5 (value_if_true
argument) otherwise it returns blank(value_if_false argument).
Output → 20

• IF( C11>=11, C6, IF(C11>=1, C5, “”)) → this becomes IF( C11>=11, C6, 20).
Output → 19
• IF(C11>=21, C7, IF( C11>=11, C6, IF(C11>=1, C5, “”))) → this becomes IF(C11>=21, C7, 19).
Output → 16
• IF(C11>=51, C8, IF(C11>=21, C7, IF( C11>=11, C6, IF(C11>=1, C5, “”)))) → this becomes IF(C11>=51, C8,
16).
Output → 15
• IF(C11>=101,C9, IF(C11>=51, C8, IF(C11>=21, C7, IF( C11>=11, C6, IF(C11>=1, C5, “”))))) → this becomes
IF(C11>=101,C9, 15).
Output → 13
• C11*IF(C11>=101,C9, IF(C11>=51, C8, IF(C11>=21, C7, IF( C11>=11, C6, IF(C11>=1, C5, “”))))) → this
becomes C11*15.
Output → 80*15 → 1200
• Following this, press the ENTER key.

401
CITS : IT & ITES - Computer Software Application - Exercise 68 CITS : IT & ITES - Computer Software Application - Exercise 68