nested IF statement question

Question

Can someone explain to me when you would use AND or Or in a nested IF function statement. In Excel 2007 Inside Out by Mark Dodge it talks about this in a practice file which is the following:

And Or Not.xlsx.

I cannot find an online copy to this practice file which is on page 509. Its 508-509 Chapter 14 of Excel 2007 Inside Out.

Answer 1

In that last link you gave I cannot get the example to paste right in Excel when I clicked on Paste Special and Text. How do I correct this?

Answer 2

In Excel 2007 Inside Out it says that you can create formulas containing up to 64 levels of nested functions which includes IF.

Answer 3

The if function can be nested 7 times only in 2010 and previous

Answer 4

The first link did not make complete sense. I was also unclear of the structure of the functions they were using in the nested IF.

The IF function can be nested 64 times but the results may not be what you would expect.

Answer 5

Hi,

the and condition is used to state that all the assumptions will be true for example

=if(and(A1=2, A2=5, A3="A"),1,0)

in the above it will return 1 if A1=2, A2=5 and A3= letter A

=if(or(A1=2,A2,5),1,0)

it will return 1 if A1=2 or A2=5

you can read more here

http://www.ozgrid.com/News/ExcelLogicalFunctionsIfAndOrVBARangeNames.htm

http://spreadsheets.about.com/od/excelfunctions/qt/or_function.htm

http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/