Formulae containing more than 7 arguments?

Z

Zakynthos

I want to input a formula to a cell that contains 10 arguments - I realise I
cannot use the IF function for more than 7 arguments. So what formula would
I use to find:

If A1 is blank, return a "1". If A1 contains a "1", return a "2", if it
contains a "2", return a "3" etc up to and including a "9"? (i.e. 10
arguments in all.

Can it be done?

Many thanks
 
Z

Zakynthos

Arvi,

Many thanks. My fault, though, that I did not express the problem clearly
enough: I'll try again.

I want to input a formula in all 81 cells in a 9 x 9 grid such that:

if any cell is blank, input a 1,2,3,4,5,6,7,8 or 9 depending on whether all
the other numbers in that row or column add up to 45 minus the number to be
input (it sort of has something to do with Sudoku)
 
S

Sloth

you can use the CHOOSE function. In your example it will look like this.

=CHOOSE(A1+1,1,2,3,4,5,6,7,8,9,10)
 
Z

Zakynthos

Sloth,

Many thanks,

I'm not sure if you were referring to my original (badly phrased) question
or the second, above:

'I want to input a formula in all 81 cells in a 9 x 9 grid such that:

if any cell is blank, input a 1,2,3,4,5,6,7,8 or 9 depending on whether all
the other numbers in that row or column add up to 45 minus the number to be
input.

I assume it was the first question, but if the second, as above, then how
would you combine a CHOOSE function with an AND to reference the sum of the
rows and columns? If not CHOOSE, could LOOKUP (or nested IF statemments?) be
used and if so how to solve the problem?

Many thanks
 
Top