| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate and multiply problem
Hi,
A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate and multiply problem
Try this:
=A1&" "&PRODUCT(B2:C2,D4) -- Biff Microsoft Excel MVP "tipoo" wrote in message ... Hi, A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate and multiply problem
If I understand correctly, try this in A1.
=A2&" "&B2*C2*D2 HTH Regards, Howard "tipoo" wrote in message ... Hi, A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate and multiply problem
Thanks heaps for a quick response but is it possible to use this formula in
cell A1. Because when put this formula it comes out zero in cell a1 Thanks "T. Valko" wrote: Try this: =A1&" "&PRODUCT(B2:C2,D4) -- Biff Microsoft Excel MVP "tipoo" wrote in message ... Hi, A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate and multiply problem
Hi Howard,
Thanks but is it possible to use this formula in cell A1 which basically means the value that you are concatenating is in the cell (A1)where you are applying the formula? "L. Howard Kittle" wrote: If I understand correctly, try this in A1. =A2&" "&B2*C2*D2 HTH Regards, Howard "tipoo" wrote in message ... Hi, A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate and multiply problem
No you can't do that. If you have "Island" in cell A1 and you try to enter
the formula into cell A1, it will displace the word "Island" and the formula will be the sole occupant of A1. You could enter this in A1 and it will return "Island 24". ="Island"&" "&PRODUCT(B2:D2) Howard "tipoo" wrote in message ... Hi Howard, Thanks but is it possible to use this formula in cell A1 which basically means the value that you are concatenating is in the cell (A1)where you are applying the formula? "L. Howard Kittle" wrote: If I understand correctly, try this in A1. =A2&" "&B2*C2*D2 HTH Regards, Howard "tipoo" wrote in message ... Hi, A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate and multiply problem
No. You can't enter the formula in A1 since A1 already contains an entry.
You have to put the formula in another cell. -- Biff Microsoft Excel MVP "tipoo" wrote in message ... Thanks heaps for a quick response but is it possible to use this formula in cell A1. Because when put this formula it comes out zero in cell a1 Thanks "T. Valko" wrote: Try this: =A1&" "&PRODUCT(B2:C2,D4) -- Biff Microsoft Excel MVP "tipoo" wrote in message ... Hi, A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate and multiply problem
Thanks heaps guys
"L. Howard Kittle" wrote: No you can't do that. If you have "Island" in cell A1 and you try to enter the formula into cell A1, it will displace the word "Island" and the formula will be the sole occupant of A1. You could enter this in A1 and it will return "Island 24". ="Island"&" "&PRODUCT(B2:D2) Howard "tipoo" wrote in message ... Hi Howard, Thanks but is it possible to use this formula in cell A1 which basically means the value that you are concatenating is in the cell (A1)where you are applying the formula? "L. Howard Kittle" wrote: If I understand correctly, try this in A1. =A2&" "&B2*C2*D2 HTH Regards, Howard "tipoo" wrote in message ... Hi, A B C D Island 2 3 4 Is it possible to first multiply digits in cell B2,C2 and D4 and then concatenate text in cell A1. Also I want to apply formula in A2. I want to see something like this in cell A1: Island 24 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct with criteria and multiply problem | Excel Discussion (Misc queries) | |||
| Concatenate problem | Excel Discussion (Misc queries) | |||
| Concatenate Problem | Excel Discussion (Misc queries) | |||
| excel, multiply problem | Excel Worksheet Functions | |||
| Concatenate Problem | Excel Worksheet Functions | |||
Linear Mode
