For a hydrology problem you are given the following equation: =IF(WorkingEnd>Cap

Question

For a hydrology problem you are given the following equation: =IF(WorkingEnd>Capacity,Capacity,IF(WorkingEnd>0,WorkingEnd,0)) Where Capacity = Cistern Capacity Inflow = Water flowing into the cistern in one day Outflow = Water used by the facility during one day PreviousQuantity = Amount in the cistern at the end of the previous day WorkingEnd =PreviousQuantity+Inflow-Outflow In this equation the role of the second IF statement is:

a. To address what happens if the amount of water in the cistern would be less than the cistern capacity - and to force the city to supply the difference.

b. To address what happens if the amount of the water in the cistern at the end of the day would be greater than the cistern capacity.

c. To address what happens if the amount of water in the cistern would be less than the cistern capacity by checking if the cistern will have some water in it and acting accordingly.

d. To check that the calculation of the cistern capacity was performed correctly.

e. To address what happens if the amount of water in the cistern would be less than the cistern capacity by checking if the cistern is empty and acting accordingly.

Explanation / Answer

the role of the second IF statement is:

c. To address what happens if the amount of water in the cistern would be less than the cistern capacity by checking if the cistern will have some water in it and acting accordingly.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.