Calculate numbers till 60
 

Hello,

I want to calculate number only till 60. Below is an example... Kindly help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

Which number is 60? And what are the relationships between A,B,C and D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example... Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

hi,

I am selling products in cartons which contain 60 pieces which is 5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10 cartons
on a single day, i dont have a problem. But when i sell in dozens ... say 10
cartons and 2.5 dozens, i have a problem. I need to keep track of each piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C and D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

If you show the data as per your second table, it will be a text field as the
number is not a valid decimal number: 279.5 converted to 279.30 really means
270 boxes and 30 pieces NOT 279.3 (decimal) boxes.

So doing any arithmetic on these values is erroneous.

Is this really what you want?

"Krishna Kumar L" wrote:

hi,

I am selling products in cartons which contain 60 pieces which is 5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10 cartons
on a single day, i dont have a problem. But when i sell in dozens ... say 10
cartons and 2.5 dozens, i have a problem. I need to keep track of each piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C and D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

Yes,

That's what i am looking for... Can you help me in this matter

Krish

"Toppers" wrote in message
...
If you show the data as per your second table, it will be a text field as
the
number is not a valid decimal number: 279.5 converted to 279.30 really
means
270 boxes and 30 pieces NOT 279.3 (decimal) boxes.

So doing any arithmetic on these values is erroneous.

Is this really what you want?

"Krishna Kumar L" wrote:

hi,

I am selling products in cartons which contain 60 pieces which is 5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10
cartons
on a single day, i dont have a problem. But when i sell in dozens ... say
10
cartons and 2.5 dozens, i have a problem. I need to keep track of each
piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C and D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

in E3:

=INT(D3) & "." & TEXT(ROUND(MOD(D3,1)*60,2),"00")

and copy down

"Krishna Kumar L" wrote:

Yes,

That's what i am looking for... Can you help me in this matter

Krish

"Toppers" wrote in message
...
If you show the data as per your second table, it will be a text field as
the
number is not a valid decimal number: 279.5 converted to 279.30 really
means
270 boxes and 30 pieces NOT 279.3 (decimal) boxes.

So doing any arithmetic on these values is erroneous.

Is this really what you want?

"Krishna Kumar L" wrote:

hi,

I am selling products in cartons which contain 60 pieces which is 5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10
cartons
on a single day, i dont have a problem. But when i sell in dozens ... say
10
cartons and 2.5 dozens, i have a problem. I need to keep track of each
piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C and D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

Sir,

I am not getting any values... Its just 0.00 only... not changing ..

Krish

"Toppers" wrote in message
...
in E3:

=INT(D3) & "." & TEXT(ROUND(MOD(D3,1)*60,2),"00")

and copy down

"Krishna Kumar L" wrote:

Yes,

That's what i am looking for... Can you help me in this matter

Krish

"Toppers" wrote in message
...
If you show the data as per your second table, it will be a text field
as
the
number is not a valid decimal number: 279.5 converted to 279.30 really
means
270 boxes and 30 pieces NOT 279.3 (decimal) boxes.

So doing any arithmetic on these values is erroneous.

Is this really what you want?

"Krishna Kumar L" wrote:

hi,

I am selling products in cartons which contain 60 pieces which is
5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10
cartons
on a single day, i dont have a problem. But when i sell in dozens ...
say
10
cartons and 2.5 dozens, i have a problem. I need to keep track of each
piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C and
D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

Have you put the other formula in D3 onwards? It works fine for me.

"Krishna Kumar L" wrote:

Sir,

I am not getting any values... Its just 0.00 only... not changing ..

Krish

"Toppers" wrote in message
...
in E3:

=INT(D3) & "." & TEXT(ROUND(MOD(D3,1)*60,2),"00")

and copy down

"Krishna Kumar L" wrote:

Yes,

That's what i am looking for... Can you help me in this matter

Krish

"Toppers" wrote in message
...
If you show the data as per your second table, it will be a text field
as
the
number is not a valid decimal number: 279.5 converted to 279.30 really
means
270 boxes and 30 pieces NOT 279.3 (decimal) boxes.

So doing any arithmetic on these values is erroneous.

Is this really what you want?

"Krishna Kumar L" wrote:

hi,

I am selling products in cartons which contain 60 pieces which is
5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10
cartons
on a single day, i dont have a problem. But when i sell in dozens ...
say
10
cartons and 2.5 dozens, i have a problem. I need to keep track of each
piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C and
D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

sorry ... formula for D3 and copy down:

=((D2-A3)*60-B3*12)/60

"Krishna Kumar L" wrote:

Sir,

I am not getting any values... Its just 0.00 only... not changing ..

Krish

"Toppers" wrote in message
...
in E3:

=INT(D3) & "." & TEXT(ROUND(MOD(D3,1)*60,2),"00")

and copy down

"Krishna Kumar L" wrote:

Yes,

That's what i am looking for... Can you help me in this matter

Krish

"Toppers" wrote in message
...
If you show the data as per your second table, it will be a text field
as
the
number is not a valid decimal number: 279.5 converted to 279.30 really
means
270 boxes and 30 pieces NOT 279.3 (decimal) boxes.

So doing any arithmetic on these values is erroneous.

Is this really what you want?

"Krishna Kumar L" wrote:

hi,

I am selling products in cartons which contain 60 pieces which is
5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10
cartons
on a single day, i dont have a problem. But when i sell in dozens ...
say
10
cartons and 2.5 dozens, i have a problem. I need to keep track of each
piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C and
D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish

Calculate numbers till 60
 

Woooo...

Thanks a lot... Hats off to you... I was breaking my head over this for
the past one week... Thanks again

Bye

Krish
"Toppers" wrote in message
...
sorry ... formula for D3 and copy down:

=((D2-A3)*60-B3*12)/60

"Krishna Kumar L" wrote:

Sir,

I am not getting any values... Its just 0.00 only... not changing ..

Krish

"Toppers" wrote in message
...
in E3:

=INT(D3) & "." & TEXT(ROUND(MOD(D3,1)*60,2),"00")

and copy down

"Krishna Kumar L" wrote:

Yes,

That's what i am looking for... Can you help me in this matter

Krish

"Toppers" wrote in message
...
If you show the data as per your second table, it will be a text
field
as
the
number is not a valid decimal number: 279.5 converted to 279.30
really
means
270 boxes and 30 pieces NOT 279.3 (decimal) boxes.

So doing any arithmetic on these values is erroneous.

Is this really what you want?

"Krishna Kumar L" wrote:

hi,

I am selling products in cartons which contain 60 pieces which
is
5
dozens. Now after every day sales i need to know the balance in my
warehouse. We sell by cartons and also by dozens. So when i sell 10
cartons
on a single day, i dont have a problem. But when i sell in dozens
...
say
10
cartons and 2.5 dozens, i have a problem. I need to keep track of
each
piece
in my inventory. So the sheet will be like the now below


A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.50

3 3 1 286.30


I want to calculate like the chart below

A B D
Box Dozen Balance
300

1 10 290

2 10 2.5 289.30

3 3 1 286.18


Kindly help in this matter.....

Krish
"Toppers" wrote in message
...
Which number is 60? And what are the relationships between A,B,C
and
D?

C=2*a, D=2*B?

Why in your example belowi is B1 & D1 blank?

A1 B1 C1 D1
65 130


"Krishna Kumar L" wrote:

Hello,

I want to calculate number only till 60. Below is an
example...
Kindly
help me..

A1 B1 C1 D1
1 05 02 10

I want it like this... the problem is

A1 B1 C1 D1
65 130


How to write a formula for this

Krish