If statement 'formula' not working

I have two if statements that I need to combine into one statement. The
first statement I have is:
=IF(S1>DATEVALUE("10/20/2005"),1,IF(S1=DATEVALUE("10/20/2005"),3,2))
the second statement I have is:
=IF(SEARCH("pen",S3),2,1)
The second statement is where I am having trouble. I tried to add this to
the first statement like so:
=IF(S1>DATEVALUE("10/20/2005"),1,IF(S1=DATEVALUE("10/20/2005"),3,IF(SEARCH("pending",S3),2,2)))

But the second statement is coming back as a 1. I am new to these if
statements so any help is greatly appreciated.
Thanks.

Hi,

Search returns the position of the match.
For instance =Search("pen","pending") will return a value of 1 but
=Search("pen","spending") will return true.
If you want to say that pen should be found somewhere in S3 then you have to
say =if (Search("pen",S3)>0,<true part>,<false part>)

Hope this helps you to find the bug.

Alok


"Bricktop" wrote:

> I have two if statements that I need to combine into one statement. The
> first statement I have is:
> =IF(S1>DATEVALUE("10/20/2005"),1,IF(S1=DATEVALUE("10/20/2005"),3,2))
> the second statement I have is:
> =IF(SEARCH("pen",S3),2,1)
> The second statement is where I am having trouble. I tried to add this to
> the first statement like so:
> =IF(S1>DATEVALUE("10/20/2005"),1,IF(S1=DATEVALUE("10/20/2005"),3,IF(SEARCH("pending",S3),2,2)))
>
> But the second statement is coming back as a 1. I am new to these if
> statements so any help is greatly appreciated.
> Thanks.

This would be a great question for the folks in the 'Excel
WorksheetFunctions' forum as this one is for programming questions.

"Bricktop" wrote:

> I have two if statements that I need to combine into one statement. The
> first statement I have is:
> =IF(S1>DATEVALUE("10/20/2005"),1,IF(S1=DATEVALUE("10/20/2005"),3,2))
> the second statement I have is:
> =IF(SEARCH("pen",S3),2,1)
> The second statement is where I am having trouble. I tried to add this to
> the first statement like so:
> =IF(S1>DATEVALUE("10/20/2005"),1,IF(S1=DATEVALUE("10/20/2005"),3,IF(SEARCH("pending",S3),2,2)))
>
> But the second statement is coming back as a 1. I am new to these if
> statements so any help is greatly appreciated.
> Thanks.