Adding Cells with a letter in one of them
 

I want to muliply 2 cells together, but one of the cells to have a letter in
it.
Cell A1 is 40p and Cell A2 is 4. Without the p in A1 a value is returned in
A3 of 160.
With the p in A1 a #Value is returned in A3.
Is there a way of getting this calculation to return the correct value of
the numbers in A1 and A2
with the p in A1.
Many thanks
Jim

Adding Cells with a letter in one of them
 

try this

=LEFT(A1,2)*A2


On Apr 7, 8:20*pm, "Jim" wrote:
I want to muliply 2 cells together, but one of the cells to have a letter in
it.
Cell A1 is 40p and Cell A2 is 4. Without the p in A1 a value is returned in
A3 of 160.
With the p in A1 a #Value is returned in A3.
Is there a way of getting this calculation to return the correct value of
the numbers in A1 and A2
with the p in A1.
Many thanks
Jim

Adding Cells with a letter in one of them
 

That does the trick!!!
Many thanks
Jim


"muddan madhu" wrote in message
...
try this

=LEFT(A1,2)*A2


On Apr 7, 8:20 pm, "Jim" wrote:
I want to muliply 2 cells together, but one of the cells to have a letter
in
it.
Cell A1 is 40p and Cell A2 is 4. Without the p in A1 a value is returned
in
A3 of 160.
With the p in A1 a #Value is returned in A3.
Is there a way of getting this calculation to return the correct value of
the numbers in A1 and A2
with the p in A1.
Many thanks
Jim

Adding Cells with a letter in one of them
 

Or, if you're not sure how many digits before the letter, try
=LEFT(A1,LEN(A1)-1)*A2
--
David Biddulph

"muddan madhu" wrote in message
...
try this

=LEFT(A1,2)*A2


On Apr 7, 8:20 pm, "Jim" wrote:
I want to muliply 2 cells together, but one of the cells to have a letter
in
it.
Cell A1 is 40p and Cell A2 is 4. Without the p in A1 a value is returned
in
A3 of 160.
With the p in A1 a #Value is returned in A3.
Is there a way of getting this calculation to return the correct value of
the numbers in A1 and A2
with the p in A1.
Many thanks
Jim