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