Adding text to the start of a formula

J

Joel

Hi I am trying to add text to the start of a forumula without success below
is what I am trying to use. Please help

Joel

=B2&"sold "&,=sum(D8:D20)
 
K

Kent Prokopy

=A1&" Sold " &B1& " Bottles of coke."

returns:
Kent Sold 15 Bottles of coke.
 
I

IanC

Just get rid of the ",=" before SUM.

=B2 & " sold " & SUM(D8:D20)

The spaces I've added aren't strictly necessary, but makes it easier to
read.
 
F

FSt1

hi
close
=B2&" "&"sold"&" "&Sum(D8:D20)
the exta " " are for spaces between the words and numbers.
worked in xp on tuesday.

regards
FSt1
 
I

IanC

=B2&" "&"sold"&" "&Sum(D8:D20)
the exta " " are for spaces between the words and numbers.
worked in xp on tuesday.
Click to expand...

A tidier way is to put the spaces either side of the "sold" string (ie "
sold "). it gets rid of 2 amperands and 4 double-quotes.

=B2&" sold "&Sum(D8:D20)
 
J

Joel

Hi thanks for all your help I tried them all and all I get is a blank cell
with a £ sign in it more help would be appreciated

Joel
 
F

FSt1

hi
you're right but i wanted them to show. which is why i pointed them out.
also give a better understanding of how it all works. sometimes the hard way
teaches more.

regards
FSt1
 
I

IanC

Hi Joel

What do you have in B2 and in D8:D20?
In a spare cell, type =B2. Do you get what B2 contains?
Try the same thing with =SUM(D8:D20). Is this correct?
Where does the £ sign come from? That's not in your formula, so I'm assuming
you've formatted as currency. If so, it shouldn't show the £ sign unless
there's something after it.
 
Top