Skip to content

Instantly share code, notes, and snippets.

@chandlerroth

chandlerroth/gist:e17bdd066a81bc4dcf3f6aee753fb457

Last active November 26, 2016 06:12
Show Gist options
  • Save chandlerroth/e17bdd066a81bc4dcf3f6aee753fb457 to your computer and use it in GitHub Desktop.
Save chandlerroth/e17bdd066a81bc4dcf3f6aee753fb457 to your computer and use it in GitHub Desktop.
Download ZIP
savings-bucket
Raw
gistfile1.txt
totalCash = 40,000
allocatedMoney = 0 = SUM(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()−1,COLUMN()))
goalAmount[0] = 10,000
goalAmount[1] = 2,000
goalAmount[2] = 5,000
if (goalAmount[1] <= (totalCash - allocatedMoney)) {
goalAmount[1]
} else {
totalCash - allocatedMoney
}
IF(
Goal Emergency Fund ≤ (Table 2::$B$2 − SUM(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()−1,COLUMN()))),
Goal Emergency Fund,
(Table 2::$B$2 − SUM(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()−1,COLUMN())))
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment