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