We help IT Professionals succeed at work.

Excel if equation

optia
optia used Ask the Experts™
on
Hello All,

I am currently trying to write an equation or a statement that returns a true or false from three columns. What I want to be able to do is check the first two columns to see if they match. If true then  check the 3rd column to make sure that the following items are entered  are not entered.
2: Intrviewd -Lost Touch
2: Intrviewd -Temp Leave
2: Intrviewd-Dbl Agent
2: Intrviewd-F2F
2: Intrviewd-Phone
4: Interviewing
3: Sendouts

 Below is a sample of the data I am using:
|user5_text|      |enterby|        |CandidStatusName|  
|Fully keyworded|      |JOSEPH|          |2:Intrviewed-phone|
|      |                 | EB|                 |2: Intrviewd-Phone|
|Hanna|                          |Hanna|            |2: Intrviewd-Phone|

Sorry if its confusing please let me know if you need any clarifaction on anything.

THanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi!

Pls, try this formula:
=IF(AND(A2=B2;A2<>"";B2<>"";C2<>"");"okey";"hmm")

Open in new window

It compare 2 columns and check 3 columns for empty or cleared cells (compare cell to "").
Can you upload your excel file with sample data and expected result for different rows?

Author

Commented:
Thank you both for the answeres I have to head out now and will get back to this tomorrow. I attached the sample data but forgot to give the expected results.
So bascily I want to verify that the columns user5_text and enterby are the same. It should return true. If that returns true then check the column CandidStatusName to see if it contains the following:
2: Intrviewd -Lost Touch
2: Intrviewd -Temp Leave
2: Intrviewd-Dbl Agent
2: Intrviewd-F2F
2: Intrviewd-Phone
4: Interviewing
3: Sendouts
if it does then it is also true.
Commented:
Try this:
=IF(AND(A2=B2;A2<>"";B2<>"";C2<>"");C2 & " " & A2;C2)

Open in new window

Author

Commented:
thanks std-usr a little modifaction and works well