Solved

# IF statement

Posted on 2014-03-25
100 Views
This is driving me crazy, can an expert resolve it please

I need to say:

IF C4 = Commission and E4  = VS then the answer is C

IF C4 = Commission and E4  = XG then the answer is B

Thanks
0
Question by:Jagwarman
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 2
• 2
• +1

LVL 5

Expert Comment

ID: 39952776
hi...

below URL should resolve your problem:

http://www.techonthenet.com/excel/formulas/if_nested.php
0

LVL 26

Accepted Solution

Shaun Kline earned 500 total points
ID: 39952780
If you are looking for a formula solution, you can use:

=if(c4="commission", if(e4="vs", "c", if(e4="xg", "b", ""), ""), "")
0

Author Comment

ID: 39952804
indrajitmahajan unfortuantely that did not help me
0

Author Comment

ID: 39952806
Shaun I took off the last two ""  and it works. Thanks

=if(c4="commission", if(e4="vs", "c", if(e4="xg", "b", "")))
0

LVL 8

Expert Comment

ID: 39952811
Try this
``````=IF(AND(C4="Commission",E4="VS"),"C",IF(AND(C4="Commission",E4="XG"),"B",""))
``````
0

LVL 5

Expert Comment

ID: 39952814
Jagwarman thats fine.. more important is to get your solution :)
0

Author Comment

ID: 39952842
itjockey that works too thanks. Sorry I can't give you any points as they already went
0

LVL 8

Expert Comment

ID: 39952849
I am not after points, I am learning every day    :)

Thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaacâ€¦
###### Suggested Courses
Course of the Month8 days, 21 hours left to enroll