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