Monday, July 29, 2019

Excel formulas

Excel formulas

There are so many excel formulas are here. The upgrade of the excel version is adding more new formulas on it. So I just try here to write some basic formulas here and time to time I post other formulas here.
  • Sum- when you want to add two or more particular cells than just type "=sum(click cell 1:click cell 2)" and type enter.
    excel sum
  • Average- If you want to open average than type "=average(first cell:last number cell of your sheet)" and press Enter.
  • Max- For opening maximum (biggest) number from the excel sheet "=max(click the first cell:click to the last cell) and Enter.
  • Min- for opening minimum(smallest) number "=min(first number from where you want to open: last number) Enter.
This is only a basic excel formula. Next time I update all other excel formulas.

No comments:

Post a Comment