Thread: IF Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default IF Function

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.