When do we use basic formula in Excel?
Most formulas in Excel are quite basic, such as formulas for SUM
functions. You use them in all sorts of situations, so it is very
much a case that you use them when you need them. In that way,
there is no specific answer to the question. So you use a basic
formula when you need to use one. You would not use a very
complicated formula, when a basic one will do.