IF function help.

[mhartle]

Hi there,

The I am trying to design a generator in excel that generates algebraic expressions.

For example

In cell B4 the formula is RANDBETWEEN(1,12)
In cells C4:29 I have letters a - z listed in a column one letter per cell.


In a separate cell from which excel reads is the formula: =B4&CHOOSE((RANDBETWEEN(1,26)),$C$4,$C$5,$C$7,$C$6,$C$8,$C$9,$C$10,$C$11,$C$12,$C$13,$C$14,$C$15,$C$16,$C$17,$C$18,$C$19,$C$20,$C$21,$C$22,$C$23,$C$24,$C$25,$C$26,$C$27,$C$28,$C$29)

For example one possible result would be 3f.

However if the result was 1m, in a separate cell I want excel to realise that B4=1 and then display it as m.

I've attached the spreadsheet aswell.

Regards
mhartle

[mhartle]

Here is the algebraic expression generator