subject

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

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 01:00
Duplicating objects creates copies that a. move differently than the original object b. erase the original object c. look and act like the original object d. add events to a game
Answers: 1
question
Computers and Technology, 23.06.2019 01:00
Write the command that can be used to answer the following questions. (hint: try each out on the system to check your results.) a. find all files on the system that have the word test" as part of their filename. b. search the path variable for the pathname to the awk command. c. find all files in the /usr directory and subdirectories that are larger than 50 kilobytes in size. d. find all files in the /usr directory and subdirectories that are less than 70 kilobytes in size. e. find all files in the / directory and subdirectories that are symbolic links. f. find all files in the /var directory and subdirectories that were accessed less than 60 minutes ago. g. find all files in the /var directory and subdirectories that were accessed less than six days ago. h. find all files in the /home directory and subdirectories that are empty. i. find all files in the /etc directory and subdirectories that are owned by the group bin."
Answers: 1
question
Computers and Technology, 23.06.2019 02:00
Read this excerpt from helen keller’s autobiography, the story of my life. have you ever been at sea in a dense fog, when it seemed as if a tangible white darkness shut you in, and the great ship, tense and anxious, groped her way toward the shore with plummet and sounding-line, and you waited with beating heart for something to happen? i was like that ship before my education began, only i was without compass or sounding-line, and had no way of knowing how near the harbour was. "light! give me light! " was the wordless cry of my soul, and the light of love shone on me in that very hour. . the morning after my teacher came she led me into her room and gave me a doll. the little blind children at the perkins institution had sent it and laura bridgman had dressed it; but i did not know this until afterward. when i had played with it a little while, miss sullivan slowly spelled into my hand the word "d-o-l-l." i was at once interested in this finger play and tried to imitate it. when i finally succeeded in making the letters correctly i was flushed with childish pleasure and pride. running downstairs to my mother i held up my hand and made the letters for doll. i did not know that i was spelling a word or even that words existed; i was simply making my fingers go in monkey-like imitation. in the days that followed i learned to spell in this uncomprehending way a great many words, among them pin, hat, cup and a few verbs like sit, stand and walk. based on this excerpt, which words best describe helen keller?
Answers: 2
question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. sean is a computer programmer. he has programmed an application for toddlers that plays nursery rhymes. however, a logic error has occurred in the program. which problem is a likely consequence of the error? a. the program crashes every time the user wants to play the nursery rhymes. b. the program crosses its buffer boundaries and overwrites an adjacent program. c. the program plays a different nursery rhyme than the one the user intended to play. d. the program shows different structures in its programming language code. e. the program introduces new viruses every time the user plays a nursery rhyme.
Answers: 1
You know the right answer?
Tomatoes in Owino market can be purchased by traders according to this price schedule: For the fir...
Questions
question
Mathematics, 12.02.2020 02:44
question
Physics, 12.02.2020 02:44
question
Mathematics, 12.02.2020 02:45
Questions on the website: 13722367