Required formula in excel

[Dnyan]

Hi,

I have one file in I have to make calculation but one thing is there I unable to do this.

<TABLE dir=ltr cellSpacing=0 cellPadding=2 width=128 border=0><TBODY><TR><TD width="50%" bgColor=#c0c0c0 height=5>
</TD><TD width="50%" bgColor=#c0c0c0 height=5>

A​

​

​

​

​

</TD></TR><TR><TD width="50%" bgColor=#c0c0c0 height=5>

1​

​

​

​

​

</TD><TD width="50%" height=5>

40cw​

​

​

​

​

</TD></TR><TR><TD width="50%" bgColor=#c0c0c0 height=5>

2​

​

​

​

​

</TD><TD width="50%" height=5>
</TD></TR><TR><TD width="50%" bgColor=#c0c0c0 height=5>

3​

​

​

​

​

</TD><TD width="50%" height=5>

45​

​

​

​

​

</TD></TR><TR><TD width="50%" bgColor=#c0c0c0 height=5>

4​

​

​

​

​

</TD><TD width="50%" height=5>

50​

​

​

​

​

</TD></TR><TR><TD width="50%" bgColor=#c0c0c0 height=5>

5​

​

​

​

​

</TD><TD width="50%" height=5>

60​

​

​

​

​

</TD></TR><TR><TD width="50%" bgColor=#c0c0c0 height=5>

6​

​

​

​

​

</TD><TD width="50%" height=5>

155​

​

​

​

​

</TD></TR><TR><TD width="50%" bgColor=#c0c0c0 height=5>

7​

​

​

​

​

</TD><TD width="50%" height=5>

#VALUE!​

​

​

​

​

</TD></TR></TBODY></TABLE>

I want formula that A7= A6/A1 i.e. A7=155/40cw

Is it possible?
Please suggest me about this.

Regards
Dnyan

 

[JamesW]

Hi there,

What is the format for the 40cw value? Is it always 2 numbers and 2 letters, or can it be 4000cwsz for example?

If it is always 2 numbers and 2 letters then try:

=A6/LEFT(A1,2)+0

 

[anglais428]

=A6/left(A1,2)

 

[Dnyan]

Hi there,

What is the format for the 40cw value? Is it always 2 numbers and 2 letters, or can it be 4000cwsz for example?

If it is always 2 numbers and 2 letters then try:

=A6/LEFT(A1,2)+0

Hi,

Thank you very much
both formulas are working properly.

Regards
Dnyan