"IF" function

  • Thread starter Thread starter Natasha
  • Start date Start date
N

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
 
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
 
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.
 
Back
Top