Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help inserting if statements within my assignment, every time I input them they come up with messages. Can someone please help me with

I need help inserting if statements within my assignment, every time I input them they come up with messages. Can someone please help me with the right format?

image text in transcribed

Below shows the message:

=IF(AND(d9>d16,d9>0),""choose the first project, NPV="&text(d9,"0.00"), IF(AND(d16>d9,d16>0)," choose the second project, NPV = "&text(something?)), "Reject both, NPV

It is complete except that I need to add another text(something?) function to the second output.

All the arguments are placed in one cell as directed and then, it is supposed to show the decision. I have tried several times, but unable to be successful. Thank you

image text in transcribed

1 TEXT function and concatenation 2 3 Year CF PVIF PV 4 0 -100 1.0000 -100.00 5 1 40 0.8929 35.71 6 2 80 0.7972 63.78 7 3 90 0.7118 64.06 8 4 30 0.6355 19.07 9 82.62 10 Year PVIF PV 11 -100 1.0000 -100.00 12 40 0.8734 34.93 13 80 0.7628 61.02 14 90 0.6662 59.96 15 30 0.5818 17.45 16 NPV = 73.36 17 choose the first project, NPV=$82.62 0 1 2 3 4 NPV = CF r= r= 12.00% Example: or function TRUE Example: and function TRUE FALSE 14.50% accept the project in d9 10 Year PVIF 11 -100 1.0000 -100.00 12 40 0.8734 34.93 13 80 0.7628 61.02 x 14 90 0.6662 59.96 You've entered too many arguments for this function. 15 30 0.5818 17.45 OK 16 NPV = 73.36 17 =if(and (d9>D16,d9>0),"choose the first project, NPV="&text(d9,"$0.00",if(and( d16>d9,d16>0,"choose the second project"),"reject both, NPV

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fintech In Islamic Finance Theory And Practice

Authors: Umar A. Oseni, S. Nazim Ali

1st Edition

1138494801, 978-1138494800

More Books

Students also viewed these Finance questions

Question

Is it clear what happens if an employee violates the policy?

Answered: 1 week ago