concatenate and multiply problem


T

tipoo

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
 
Ad

Advertisements

L

L. Howard Kittle

If I understand correctly, try this in A1.

=A2&" "&B2*C2*D2

HTH
Regards,
Howard
 
T

tipoo

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

tipoo

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

L. Howard Kittle

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
 
Ad

Advertisements

T

T. Valko

No. You can't enter the formula in A1 since A1 already contains an entry.

You have to put the formula in another cell.
 
Ad

Advertisements

T

tipoo

Thanks heaps guys

L. Howard Kittle said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top