You would have to link the formulas, so B1, C1 etc. would have formulas that
test A1 or the cell with that formula in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gixxer_J_97" wrote in message
...
hi all

is there a way to perform multiple actions in an IF statement

ie
=IF(ISBLANK(A1),<set current cell value = "";<set Cell B1 value = 0;<set
Cell C1 value = 0,<set Current cell value = A1+1;<set cell b1 value =
1;<set cell c1 value = 1)

if A1 is blank, then the current cell is 'blank', B1 contains 0, C1
contains 0
else current cell =A1+1, B1 contains 1, C1 contains 1

if that is not possible, is it possible to set the value of another cell
to
a certain value (other than the one the formula is in).

tia

J