Thread: concatenate formula result with text ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Rich is offline
external usenet poster
  
Posts: 298
Default concatenate formula result with text ?
This is my pseudocode. Two question actually: 1) how can I concatenate the
following? --(B5/B3) * 100 is numeric -- add text to this result?

(B50,(B5/B3)*100 & " % increase", (B5/B3) * 100 & " % decrease)

2) how to eliminate trailing decimals and only have a whole number from
(B5/B3) * 100?

Thanks
Reply With QuoteReply With Quote