Ask a Question
Categories
what is the difference between Function and Formula with suitableexample
Debabrata
on 2012-11-10 10:30:00in ms excel??
Arindam
on 2012-11-29 10:30:00what is the difference between Function and Formula in excel? Ans:- A function is a built in set of executable codes to perform a specific task. For example, the Sum() function will add a group of numbers within the range specified in the parenthesis. But what if you want to add half the numbers, then add the other half , and multiply the two sums together. There is no prebuilt function in Excel to do that. You need to write a formula. A formula is a set of commands to generate a specific result. The commands may include functions. For example, I could write a simple formula: =sum(a1:a12)*sum(b1:b12). This formula combines the Sum function with the multiplication operator to create the formula,
Arindam
on 2012-11-29 10:30:00what is the difference between Function and Formula? Ans:- • It has become commonplace to make use of excel spreadsheet as a calculator these days, but it requires mastering formulas and functions to be able to do so. • There are formulas and also pre defined formulas in Excel to help in complex calculations. • The pre defined formulas are known as functions • One has to devise his formula if he is desirous of making specific calculations.