How to use the Excel CBC2BIN formula | CBC2BIN formula How to use it

	Decimal Number	Binary Equivalent
	0	0	=DEC2BIN(C4)
	1	1	=DEC2BIN(C5)
	2	10	=DEC2BIN(C6)
	3	11	=DEC2BIN(C7)
	511	111111111	=DEC2BIN(C8)
	512	#NUM!	=DEC2BIN(C9)
	-1	1111111111	=DEC2BIN(C10)
	-2	1111111110	=DEC2BIN(C11)
	-3	1111111101	=DEC2BIN(C12)
	-511	1000000001	=DEC2BIN(C13)
	-512	1000000000	=DEC2BIN(C14)
	Decimal Number	Places To Pad	Binary Equivalent
	1	1	1	=DEC2BIN(C17,D17)
	1	2	01	=DEC2BIN(C18,D18)
	1	3	001	=DEC2BIN(C19,D19)
	1	9	000000001	=DEC2BIN(C20,D20)
	-1	1	1111111111	=DEC2BIN(C21,D21)
What Does It Do ?
This function converts a decimal number to its binary equivalent.
It can only cope with decimals ranging from -512 to 511.
The result can be padded with leading 0 zeros, although this is ignored for negatives.
Syntax
=DEC2BIN(DecimalNumber,PlacesToPad)
The PlacesToPad is optional.
Formatting
No special formatting is needed.

how to use dcounta formula in excel | dcounta formula in excel how it,s work | dcounta formula | what is dcounta

							This is the Database range.
Product	Wattage	Life Hours	Brand	Unit Cost	Box Quantity	Boxes In Stock	Value Of Stock
Bulb	200	3000	Horizon	£4.50	4	3	£54.00
Neon	100	2000	Horizon	£2.00	15	2	£60.00
Spot	60						£0.00
Other	10	8000	Sunbeam	£0.80	25	6	£120.00
Bulb	80	1000	Horizon	£0.20	40	3	£24.00
Spot	100	unknown	Horizon	£1.25	10	4	£50.00
Spot	200	3000	Horizon	£2.50	15	1	£37.50
Other	25	unknown	Sunbeam	£0.50	10	3	£15.00
Bulb	200	3000	Sunbeam	£5.00	3	2	£30.00
Neon	100	2000	Sunbeam	£1.80	20	5	£180.00
Bulb	100	unknown	Sunbeam	£0.25	10	5	£12.50
Bulb	10	800	Horizon	£0.20	25	2	£10.00
Bulb	60	1000	Sunbeam	£0.15	25	1	£3.75
Bulb	80	1000	Sunbeam	£0.20	30	2	£12.00
Bulb	100	2000	Horizon	£0.80	10	5	£40.00
Bulb	40	1000	Horizon	£0.10	20	5	£10.00
Count the number of products of a particular Brand which have a Life Hours rating.
			Brand	These two cells are the Criteria range.
		Type the brand name :	Horizon
		The COUNT value of Horizon is :	7	=DCOUNT(B3:I19,D3,E23:E24)
What Does It Do ?
This function examines a list of information and counts the values in a specified column.
It can only count values, the text items and blank cells are ignored.
Syntax
=DCOUNT(Database Range,FieldName,CriteriaRange)
The Database Range is the entire list of information you need to examine, including the
Field names at the top of the columns.
The Field Name is the name, or cell, of the values to Count, such as "Value Of Stock" or I3.
The Criteria Range is made up of two types of information.
The first set of information is the name, or names, of the Fields(s) to be used as the basis
for selecting the records, such as the category Brand or Wattage.
The second set of information is the actual record, or records, which are to be selected, such
as Horizon as a brand name, or 100 as the wattage.
Formatting
No special formatting is needed.
Examples
The count of a particular product, with a specific number of boxes in stock.
			Product	Boxes In Stock
			Bulb	5
		The number of products is :	3	=DCOUNT(B3:I19,H3,E50:F51)
This is the same calculation but using the name "Boxes In Stock" instead of the cell address.
			3	=DCOUNT(B3:I19,"Boxes In Stock",E50:F51)
The count of the number of  Bulb products equal to a particular Wattage.
			Product	Wattage
			Bulb	100
		The count is :	2	=DCOUNT(B3:I19,"Boxes In Stock",E61:F62)
The count of Bulb products between two Wattage values.
			Product	Wattage	Wattage
			Bulb	>=80	<=100
		The count is :	4	=DCOUNT(B3:I19,"Boxes In Stock",E68:G69)