Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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(S1DATEVALUE("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(S1DATEVALUE("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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement 'formula' not working
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(S1DATEVALUE("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(S1DATEVALUE("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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement 'formula' not working
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(S1DATEVALUE("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(S1DATEVALUE("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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statement not working | Excel Worksheet Functions | |||
IF Statement not working | Excel Worksheet Functions | |||
If statement working only once | Excel Worksheet Functions | |||
If Statement Not Working | Excel Worksheet Functions | |||
If statement not working right | Excel Programming |