Calculate numbers till 60

[Krishna Kumar L]

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

 

[Guest]

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]

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

 

[Guest]

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]

Yes,

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

Krish

 

[Guest]

in E3:

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

and copy down

 

[Krishna Kumar L]

Sir,

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

Krish

 

[Guest]

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

 

[Guest]

sorry ... formula for D3 and copy down:

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

 

[Krishna Kumar L]

Woooo...

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

Bye

Krish