| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding letter at the end of cell | Excel Discussion (Misc queries) | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| Summing all cells containing the letter K | Excel Worksheet Functions | |||
| Adding a letter to the beginning of each part number of a column | Excel Discussion (Misc queries) | |||
| Adding A range of cells that have a certain text letter | Excel Worksheet Functions | |||
![Jim[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
