Question
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?
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
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, NPVStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started