Excel Magic Trick 1428

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

DESCRIPTION

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply