I need to select randomly between two strings, say A and B.I do =CHOOSE(RANDBETWEEN(1,2), one, two)It doesn't work.Neither =CHOOSE(1, one, two)It shows ERROR.
Google sheets: is CHOOSE different from Excel?
google spreadsheets
Both formula's work as intended, see screenshot.ScreenshotNoteAs mentioned in my comment, the CHOOSE formula is present in Excel and Google Sheets.You need to use a semicolon in stead of a comma.ExampleI've created an example file for you: CHOOSEReferenceLocale ExampleExcel vs. Google Spreadsheets (old)