When would want to create and solve a formula manually without using a function?

Can someone please explain to me in what scenario would someone want or need to type in a formula and calculate it manually without using a function like SUM or VLOOKUP? Can I also see some examples?...