ExcelBanter - How to display 123 by "" + if(true,1+1,2+2)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to display 123 by "" + if(true,1+1,2+2)? (https://www.excelbanter.com/excel-worksheet-functions/119490-how-display-123-if-true-1-1-2-2-a.html)

Eric

How to display 123 by "" + if(true,1+1,2+2)?

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

Bob Phillips

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

Eric

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

All times are GMT +1. The time now is 01:13 AM.