ExcelBanter - populate cell with muti lingual text

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

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

- - populate cell with muti lingual text (https://www.excelbanter.com/excel-worksheet-functions/171541-populate-cell-muti-lingual-text.html)

JohnAin

populate cell with muti lingual text

How can I load a text cell with either english or French depending on what
language the user chose?

ShaneDevenshire

populate cell with muti lingual text

Hi John,

You would have to use an IF statement, for example suppose they enter either
English or French in cell A1, in B1 you might have a formula like:

=IF(A1="English","Yes","Oui")

--
cheers,
Shane Devenshire

"JohnAin" wrote:

How can I load a text cell with either english or French depending on what
language the user chose?

All times are GMT +1. The time now is 03:35 PM.