Calculate numbers till 60

  • Thread starter Thread starter Krishna Kumar L
  • Start date Start date
K

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
 
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
 
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
 
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?
 
Sir,

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

Krish
 
Woooo...

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

Bye

Krish
 
Back
Top