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.

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.

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"ManhattanRebel" wrote:

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.