How to use nested IF statements

M

marv

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi everyone,
was wondering if anyone could help me figure out using nested IF statements in excel 2008.I'm used to using it in windows XP and the procedure is pretty straight forward: to nest a statement you just click on the IF button in the "name bar" when you are in the IF False box.....that doesn't seem to work here....any suggestions would be appreciated,thanks.
 
C

Carl Witthoft

Dunno what "clicking on IF" does, but just type away -- making sure you
know whether you want to nest your "IFs" in the True or False outcome.

e.g.

=IF(A1>5,B1,IF(C1<3,D1,"null") )

Keep in mind that there are better ways to code the conditionals if you
have more than 2 or three nested "IF" statements.
 
Top