IF Function

M

ManhattanRebel

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.
 
B

Bernard Liengme

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
 
S

Shane Devenshire

Hi,

When you are asking multiple questions, it often turns out that you should
use VLOOKUP instead of nested IF's, if you show us sample data we might
poiint you in the best direction.
 
Top