Validation in IF string

P

papajoe

Does anyone know how to include a LIST (Validation) in an If string?

e.g. =if (J12="M"; "N.A"; LIST["Pool balance"; "Account balance"])

i.e. if J12 not equal to M then I would like the user to chose between "pool
balance" and "accountr balance"

/ J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top