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

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