Jan 10 2018
06:50 AM
- last edited on
Jul 25 2018
10:43 AM
by
TechCommunityAP
Jan 10 2018
06:50 AM
- last edited on
Jul 25 2018
10:43 AM
by
TechCommunityAP
Hello,
in my project I had to use formula NPV twice in calculations for different investments. Now I need to find the valuation for which both these NPV values will make equal. I was given a prompt to use the WHATIF formula, but I have never heard about that one and I can't find anything on the internet. Does anyone know what formula should I use??
Best,
Kasia
Jan 10 2018 07:33 AM
SolutionKasia,
There is no formula in Excel called: WHATIF!
What-If is a set of analysis tools that can be used in forecasting.
Here are some resources on this topic:
Introduction to What-If Analysis
Jan 10 2018 07:33 AM
SolutionKasia,
There is no formula in Excel called: WHATIF!
What-If is a set of analysis tools that can be used in forecasting.
Here are some resources on this topic:
Introduction to What-If Analysis