Thread: Help! cells a=1; b=2;c=3 how to make cell d=a+b*c show 1+2*3
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default Help! cells a=1; b=2;c=3 how to make cell d=a+b*c show 1+2*3
You could do it like this:

=A1&" + "&B1&" * "&C1

Hope this helps.

Pete

On Oct 12, 10:31 am, vaso82 wrote:
i've searched microsoft.public.excel with keywords "formula
substitute values", but haven't found the answer.
Please help if you know how to do it.
Thanks in advance!


Reply With QuoteReply With Quote