MS Excel: How to utilize the CELL Function (WS)
This Excel instructional exercise discloses how to utilize the Excel CELL work with language structure and cases.
Depiction
The Microsoft Excel CELL capacity can be utilized to recover data about a cell. This can incorporate substance, designing, estimate, and so on.
The CELL work is a worked in work in Excel that is classified as an Information Function. It can be utilized as a worksheet work (WS) in Excel. As a worksheet work, the CELL capacity can be entered as a component of a recipe in a cell of a worksheet.
Language structure
The language structure for the CELL work in Microsoft Excel is:
CELL( sort, [range] )
Parameters or Arguments
sort
The kind of data that you'd get a kick out of the chance to recover for the cell. sort can be one of the accompanying esteems:
Value Explanation
"address" Address of the cell. On the off chance that the cell alludes to a range, it is the primary cell in the range.
"col" Column number of the cell.
"color" Returns 1 if the shading is a negative esteem; Otherwise it returns 0.
"contents" Contents of the upper-left cell.
"filename" Filename of the record that contains reference.
"format" Number configuration of the cell. See illustration arranges beneath.
"parentheses" Returns 1 if the cell is designed with enclosures; Otherwise, it returns 0.
"prefix" Label prefix for the cell.
* Returns a solitary quote (') if the cell is left-adjusted.
* Returns a twofold quote (") if the cell is correct adjusted.
* Returns a caret (^) if the cell is focus adjusted.
* Returns an oblique punctuation line (\) if the cell is fill-adjusted.
* Returns an unfilled content an incentive for all others.
"protect" Returns 1 if the cell is bolted. Returns 0 if the cell is not bolted.
"row" Row number of the cell.
"type" Returns "b" if the cell is void.
Returns "l" if the cell contains a content steady.
Returns "v" for all others.
"width" Column width of the cell, adjusted to the closest whole number.
"organize"
For the "organization" esteem, depicted over, the qualities returned are as per the following:
Returned Value
for "format" Explanation
"G" General
"F0" 0
",0" #,##0
"F2" 0.00
",2" #,##0.00
"C0" $#,##0_);($#,##0)
"C0-" $#,##0_);[Red]($#,##0)
"C2" $#,##0.00_);($#,##0.00)
"C2-" $#,##0.00_);[Red]($#,##0.00)
"P0" 0%
"P2" 0.00%
"S2" 0.00E+00
"G" # ?/? or, then again # ??/??
"D4" m/d/yy or m/d/yy h:mm or mm/dd/yy
"D1" d-mmm-yy or dd-mmm-yy
"D2" d-mmm or dd-mmm
"D3" mmm-yy
"D5" mm/dd
"D6" h:mm:ss AM/PM
"D7" h:mm AM/PM
"D8" h:mm:ss
"D9" h:mm
extend
Discretionary. It is the cell (or range) that you wish to recover data for. On the off chance that the range parameter is overlooked, the CELL capacity will accept that you are recovering data for the last cell that was changed.
Returns
The CELL work returns data about a cell.
Applies To
Exceed expectations 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Kind of Function
Worksheet work (WS)
Case (as Worksheet Function)
How about we take a gander at some Excel CELL work cases and investigate how to utilize the CELL work as a worksheet work in Microsoft Excel:
Microsoft Excel
In view of the Excel spreadsheet over, the accompanying CELL illustrations would return:
=CELL("col", A1)
Result: 1
=CELL("address", A2)
Result: "$A$2"
=CELL("format", A2)
Result: "P2"
if You want the live session of Cell Function then watch
All course of Excel
0 comments:
Post a Comment