"IF" function

[Natasha]

Hi, does anyone know how to use "if" function which enables 2 actions to
be performed at the same time given that a particular condition is met?


For example, if a certain cell (C1)>5 then C2=C1-1 and C3=C1-2.

Thanks. N

 

[Dan E]

Natasha,

This would require 2 IF statements on in cell C2
=IF(C1>5, C1-1, other condition)
and one in cell C3
=IF(C1>5, C1-2, other condition)

Dan E

 

[OZZIE]

HOW ABOUT TWO FORMULAE

IN C2 =IF(C1>5,C1-1,?)
IN C3 =IF(C1>5,C1-2,?)

REPLACE THE "?" WITH WHATEVER IS SUPPOSED TO HAPPEN IF THE
C1<5.