View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to display 123 by "" + if(true,1+1,2+2)?

Thank you very much
Eric

"Bob Phillips" wrote:

Perhaps

=""&IF(I110,2,0)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Eric" wrote in message
...
Does anyone know how to code following into 123
by "" + if(true,1+1,2+2)? which display a string plus an integer into a

cell.
Thank you for any suggestion
Eric