It is called 'nesting'
=IF(A1=2, "The value is 2",IF(A1=3,"Its three",IF(A1=4,"A four", "Not 2 or 3
or 4")))
In versions before Excel 2007 you can nest to seven levels
In Excel 2007 it is 64
If you need many IF's it is better to forget them an use a lookup formula
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"ManhattanRebel" wrote in message
...
I know how to write a formula using the if function if sum equals one thing
or the other.
I need to know how to write a formula for if this then this, or if this
then
this, or if this then this.