Tomatoes in Owino market can be purchased by traders according to this price schedule: For the first 10 baskets11,000 per basket
For any of the next 20 baskets10,000 per basket
For any tomatoes beyond 20 baskets9,000 per basket

Create a spreadsheet that will calculate the total price of buying x baskets of tomatoes, where x is a number to be entered into a cell on the spreadsheet. Notes Creating this spreadsheet requires the use of Excel’s powerful IF statement. The syntax of the IF statement is a three-part “if-then-else” format. If the test condition (the first parameter) evaluates to true, the value-if-condition-true (the second parameter) is returned. But if the test condition evaluates to false, the value-if-condition-false (the third parameter) is returned.
=IF(condition-to-test, value-if-condition-true, value-if-condition-false) A simple example: =IF(Sky-is-blue, sunny-day, cloudy-day)
IF statements can be nested, although to retain clarity in your work it’s generally not a good idea to nest them to very many levels. A nested IF statement (where the nested IF takes the place of the value-if-condition-false in the original IF statement) might look like this:
=IF(condition-to-test, value-if-condition-true, IF(condition-to-test, value-ifcondition-true, value-if-condition-false))

Required
In your groups create your own scenario and use an if statement similar to the example above