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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Chart Tab Names 0
Question mark on Excel 2008 in Dock 1
Using COUNTIF but blank cell if zero 3
Help menu malfunction 3
breaking text into multiple cells 5
How to hyperlink to another sheet in the same workbook 3
"Add data" to chart menu command won't work 0

Top