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