Adding Cells with a letter in one of them

's Computer Specifications

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

's Computer Specifications

try this

=LEFT(A1,2)*A2

On Apr 7, 8:20*pm, "Jim" <j...@yahoo.co.uk> 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

's Computer Specifications

That does the trick!!!
Many thanks
Jim

"muddan madhu" <(E-Mail Removed)> wrote in message
news:33d6b392-0c39-4bb0-bac5-(E-Mail Removed)...
try this

=LEFT(A1,2)*A2

On Apr 7, 8:20 pm, "Jim" <j...@yahoo.co.uk> 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

's Computer Specifications

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

"muddan madhu" <(E-Mail Removed)> wrote in message
news:33d6b392-0c39-4bb0-bac5-(E-Mail Removed)...
try this

=LEFT(A1,2)*A2

On Apr 7, 8:20 pm, "Jim" <j...@yahoo.co.uk> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding comment to cells not working with merged cells	=?Utf-8?B?bWNwaGM=?=	Microsoft Excel Programming	2	29th Aug 2007 07:09 PM
Adding a number to a letter of the alphabet to get a letter	mike_ward99@hotmail.com	Microsoft Excel Worksheet Functions	5	21st May 2007 04:25 PM
Adding A range of cells that have a certain text letter	=?Utf-8?B?RGF2ZQ==?=	Microsoft Excel Worksheet Functions	6	7th Sep 2006 06:13 PM
Adding A range of cells that have a certain text letter	=?Utf-8?B?RGF2ZQ==?=	Microsoft Excel Worksheet Functions	0	7th Sep 2006 05:32 PM
Adding colour to a range of cells based on one of the cells v...	=?Utf-8?B?TWNLZW5uYQ==?=	Microsoft Excel Misc	4	11th Mar 2005 02:25 PM