Computer Science, asked by Resah, 11 months ago

Differentiate between use of COLON or a COMMA in a formulas and function in an excel spreadsheet program

Answers

Answered by anayalithash76

Answer:

A comma in an Excel formula means it is the end of one argument and the start of the next. Lets look at an example using the VLOOKUP function. The VLOOKUP function has 4 arguments which are: Lookup Value.

The colon tells Excel to include all cells between the two endpoint cell references. If I just wanted to input the B column into a function, the reference would be B1:B7. If I wanted to input row 5 into a function, the reference would be A5:C5.

Explanation:

Previous Question

Next Question