Formulae containing more than 7 arguments?
 

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

Formulae containing more than 7 arguments?
 

Hi

=SUM(A1)+1


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Zakynthos" wrote in message
...
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

Formulae containing more than 7 arguments?
 

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)



"Arvi Laanemets" wrote:

Hi

=SUM(A1)+1


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Zakynthos" wrote in message
...
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

Formulae containing more than 7 arguments?
 

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)

"Zakynthos" wrote:

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

Formulae containing more than 7 arguments?
 

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




"Sloth" wrote:

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)

"Zakynthos" wrote:

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