Need help (very new to this field)

wow! that is a very creative solution! so, is this a common method of creating conditional +mathematical formulas?
Im planning on setting up lots of formulas for some data, so for these kind of operations (essentially transforming data similar to excel), is there a method or is it formula based?