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

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

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

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

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

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