Excel Magic Trick 1428

VLOOKUP, COUNTIFS & IF Helper Column to Calculate Asset Current Value


See how to create a formula that will calculate the Current value of an investment for each row of the table. The table has the yearly Growth Rate and Asset Name. See how to use COUNTIFS, VLOOKUP and The IF Function to correctly calculate current asset value for each row.


Download “Excel Magic Trick 1427-1430.zip” Excel-Magic-Trick-1427-1430.zip – Downloaded 49 times – 1 MB

Be the first to comment

Leave a Reply