Forum Discussion
Need help with formula
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
Kasia,
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
- Haytham AmairahSilver Contributor
Kasia,
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
- Kasia WnukCopper Contributor
Thank U very, very much!