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
|