Forum Discussion

Clebl004's avatar
Clebl004
Copper Contributor
Oct 11, 2023

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?...
Formulas and Functions
peiyezhu's avatar
peiyezhu
Bronze Contributor
Oct 11, 2023
without using a function like SUM or VLOOKUP

what do you mean without SUM or Vlookup?
Clebl004's avatar
Clebl004
Copper Contributor
Oct 12, 2023

When would you create a formula without using the preset functions? What reason would you want to calculate a formula manually vs. automatically with =SUM or =AVERAGE? peiyezhu