how to nest several functions together

[pboost1]

I am not sure how do nest several functions together. Which would go o
the inside first? If I wanted several IF statements together, ho
would I do that? Thanks for any help that can be given

 

[Byers]

It will start with the outer one first. The structure of an if statmen
is that it's if(test value, return if true, return if false)

to nest that you do if(testvalue, return if true, if(testvalue, retur
if true, return if false))

so for the first if statment it tests it and returns that value if it'
true, if it's not true it goes into the second if statement.

you can only nest like 7 or 8 otherwise you get an error

 

[Guest]

Example: nesting if statements

IF(A1=1,"x",IF(A1=2,"y",IF(A1=3,"z","-")))

 

[Debra Dalgleish]

There are example of nested functions in Excel's help files. Search for
Help on the IF function, and you'll find the information shown here:


http://office.microsoft.com/assista...ID=HP052091181033&CTT=4&Origin=CH062528271033

Also, for information and examples on Excel's functions, you can
download Peter Noneley's Function Dictionary:

http://homepage.ntlworld.com/noneley/