Archive for the ‘Excel function’ Category

The function of Excel is terrible and convenient.

There is saying as the function in Excel, and this is terribly convenient. It is possible to operate it, and h [...]…

Read the rest of this entry »

The function of Excel is terrible.

I think that there are a lot of bills even on business and usually, household account books Excel, and a takin [...]…

Read the rest of this entry »

Excel function (chapter MATCH)

I introduce the function to retrieve the position. 【 function 】 =MATCH (retrieved value, retrieved range, and [...]…

Read the rest of this entry »

Do to take data correctly?

When data is taken into Excel, it is not possible to take it by feeling “NULL is illegal” includin [...]…

Read the rest of this entry »

Excel function (retrieval function)

I introduce the method to do by the following Excel. 【 problem 】 I want to display minimum value from two or m [...]…

Read the rest of this entry »

Function of Excel (character-string handling)

1.It is a function that can unite the character, the numerical value, the cell, and the numerical result, etc. [...]…

Read the rest of this entry »

Excel function (function concerning total)

1.I introduce the function to request the total value. 【 function 】 =SUM (1 and 2 and ..numerical value.. ..nu [...]…

Read the rest of this entry »

How to use of the Excel function.

I introduce the usage of the function of some Excel to the following. 1.Function from which mean value is requ [...]…

Read the rest of this entry »

Function of Excel (character string substitution)

【 function 】 “= SUBSTITUTE (former character string, retrieval character, substitution character, and ob [...]…

Read the rest of this entry »