The formula documentation examples leave a lot to be desired. Primarily because they dont include the example data that they are manipulating. They only show the formula and you have no clue how they actually fit into a scenario. For example looks at the and() documentation:
this ones easy to learn but the example is poor:
And (value)
Returns true if all the items are true, otherwise false
And(value)
Returns true if all the items are true, otherwise false
And(Today() > Date(2015, 4, 23), Bugs.Count() < 5)
true
We dont have the dataset to look at to see how many bugs there are. the formula suggests its less than 5, but we have to infer that from the example instead of seeing how the formula takes the inputs and gives the output of true.
there are many other examples like this where you dont see the input data so you have to mentally figure out what its working with. just a simple example data row would make this much clearer on a lot of formulas.