Challenge #425: Weekly Allowance Distribution

[arshadejaz1]

Completed

[AnnaMikhaylova]

Solved.

[a640687]

Spoiler

Expression for Multi-Row Formula Tool:

Spoiler

IF [Name] = "Column_1_Amount" THEN [Value]
ELSEIF [Name] = "Column_2_Amount" THEN IF [Row-1:Value] - 150 > 0 THEN 150 ELSE 0 ENDIF
ELSEIF [Name] = "Column_3_Amount" THEN IF [Row-2:Value] - 300 > 0 THEN 150 ELSE [Row-2:Value] - [Row-1:Value] ENDIF
ELSEIF [Name] = "Column_4_Amount" THEN IF [Row-3:Value] - 450 > 0 THEN 150 ELSE [Row-3:Value] - [Row-1:Value] - [Row-2:Value] ENDIF
ELSEIF [Name] = "Column_5_Amount" THEN IF [Row-4:Value] - 600 > 0 THEN 150 ELSE [Row-4:Value] - [Row-1:Value] - [Row-2:Value] - [Row-3:Value] ENDIF
ELSEIF [Name] = "Column_6_Amount" THEN [Row-5:Value] - [Row-1:Value] - [Row-2:Value] - [Row-3:Value] - [Row-4:Value]
ELSE 0
ENDIF

[jassik]

Here is the solution

[Deborah_Simmonds]

Here's my VERY analogue solution! 

[AshaDaniels]

Spoiler

[Yogesh1795]

Used Iterative Macro to solve this one as well. Relly getting comfortable with Iterative Macros

[Bhaskar39]

Using Formula tool alone

[Tjaronee]

My solution

[lwolfie]

Love ending my week with challenges like this.