Question: use IF functions, to create a formula that: - Displays the caption Purchase and Lease are Equal Options for the case where the calculated values

use IF
functions, to create a formula that:
- Displays the caption Purchase and Lease are Equal Options for the case where the calculated values
in cells E21 and E33 are the same
- Displays the caption NPV of Purchase Option Better by: for the case where the calculated value in
cell E21 is higher than the calculated value in cell E33
- Displays the caption NPV of Lease Option Better by: for the case where the calculated value in cell
E21 is lower than the calculated value in cell E33

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!