Which If-Then-Else statement will allow you to avoid a division by zero in the function:
Public Function Perpetuity(Dividend As Single, ReqReturn As Single, DivFreq As Single) As Single
Perpetuity = Dividend/(ReqReturn/DivFreq)
End Function
a) If ReqReturn > 0 Then
Perpetuity = Dividend/(ReqReturn/DivFreq)
Else
Perpetuity = CVErr(xlErrValue)
End If
b) If ReqReturn <> 0 Then
Perpetuity = Dividend/(ReqReturn/DivFreq)
Else
Perpetuity = CVErr(xlErrValue)
End If
c) If ReqReturn = 0 Then
Perpetuity = CVErr(xlErrValue)
Else
Perpetuity = Dividend/(ReqReturn/DivFreq)
End If
d) All of the above
e) None of the above
d) All of the above
You might also like to view...
Although focus groups should encourage open, free-wheeling information, who has the task of ensuring that the conversation stays focused?
A) focus group manager B) focus group moderator C) focus group gate keeper D) quantitative research assistant (QRA) E) none of the above
A group's ________ are the things group members do and say that directly aid in the accomplishment of its objectives.
A. maintenance roles B. cultural roles C. self-interest roles D. task roles
When is a creditor a secured creditor?
A) the creditor has been guaranteed payment by a trustee B) the creditor gives a loan without security C) the creditor has been paid back his debt D) the creditor has acquired collateral
In part-period balancing lot-sizing technique, ______.
A. the order interval is fixed B. the order quantity is variable C. the order quantity depends on price D. the order quantity depends on safety stock