SOLVED

Need help with formula

Copper Contributor

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

 

2 Replies
best response confirmed by Kasia Wnuk (Copper Contributor)
Solution

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

What-If Analysis

Using What-If Analysis

 

Thank U very, very much!

1 best response

Accepted Solutions
best response confirmed by Kasia Wnuk (Copper Contributor)
Solution

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

What-If Analysis

Using What-If Analysis

 

View solution in original post