The Basic Excel Functions. The following formula would tell Excel to add up cells D4 through D6. For example if value1 through value7 are the days of the week CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.
There are simple functions in Excel such as SUM AVERAGE and COUNT.
These MS Excel functions comes in handy when you need to find certain information in a table based on a value in one column or return a reference to a certain cell. Before we start to delve into mathematical functions in Excel 2016 lets start out by reviewing the very basic mathematical functions that you are probably. But Excel is more powerful than that because of these so-called functions. Returns the Arcsine of a number.