You can get #VALUE! if there is text in one or more of C1:E1.
--
David Biddulph

"Ian Elliott" wrote in message
...
Thanks for any help.
I am trying to get a cell with a formula and text.
Something like for A1
=B1*C1&"% - "&D1*E1
But I get a #VALUE! error for this. However, when I opened another new
workbook, I could do it without error. I tried changing the cell format to
general, but to no avail. Any ideas?
Thanks.