I have put together a simple future value spreadsheet. See attached.
Column F represents present value. I see that I need to input the value as negative for Column I to show as a positive value. I want to create a template of this for different clients. Is there a way to enter the value in Col F and have it automatically be a negative number? This will also result in Col I values not showing red. FV.xlsx
Thank you. Peterino
Bookmarks