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...

Formulas & Functions

Requests

Haytham Amairah
Jan 10, 2018
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/