excel present value function will open the function arguments dialogue box where we enter cell as seen below as you can see we have made the present value negative excel formula present value of futur.