Question

Tomatoes in Owino market can be purchased by traders according to this price schedule: For the first 10 baskets 11,000 per basket For any of the next 20 baskets 10,000 per basket For any tomatoes beyond 20 baskets 9,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

Answer 1

To create a spreadsheet that calculates the total price of buying x baskets of tomatoes, you can use the IF statement in Excel. Here's how you can set it up: In cell A1, enter the number of baskets you want to buy. In cell B2, enter the following formula: =IF(A1<=10,A1*11000,IF(A1<=30,(A1-10)*10000+110000,(A1-30)*9000+230000))

Step-by-step explanation:

To create a spreadsheet that calculates the total price of buying x baskets of tomatoes, you can use the IF statement in Excel. Here's how you can set it up:

1. In cell A1, enter the number of baskets you want to buy.
2. In cell B2, enter the following formula:
   =IF(A1<=10,A1*11000,IF(A1<=30,(A1-10)*10000+110000,(A1-30)*9000+230000))
3. This formula will check the value in cell A1 and calculate the total cost based on the given price schedule. It calculates the cost for the first 10 baskets at 11,000 per basket, the next 20 baskets at 10,000 per basket, and any additional baskets at 9,000 per basket.