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:
https://support.office.com/en-us/article/Introduction-to-What-If-Analysis-22bffa5f-e891-4acc-bf7a-e4645c446fb4
http://www.excel-easy.com/data-analysis/what-if-analysis.html
https://www.gcflearnfree.org/excel2010/using-whatif-analysis/1/
2 Replies
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:
https://support.office.com/en-us/article/Introduction-to-What-If-Analysis-22bffa5f-e891-4acc-bf7a-e4645c446fb4
http://www.excel-easy.com/data-analysis/what-if-analysis.html
https://www.gcflearnfree.org/excel2010/using-whatif-analysis/1/
Thank U very, very much!
