Monday, 11 September 2017

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.


Thursday, 7 September 2017

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)