Solved

IF statement

Posted on 2014-03-25
8
100 Views
Last Modified: 2014-03-25
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
Comment
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
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 5

Expert Comment

by:indrajitmahajan
ID: 39952776
hi...

below URL should resolve your problem:

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

Accepted Solution

by:
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

by:Jagwarman
ID: 39952804
indrajitmahajan unfortuantely that did not help me
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Author Comment

by:Jagwarman
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

by:Naresh Patel
ID: 39952811
Try this
=IF(AND(C4="Commission",E4="VS"),"C",IF(AND(C4="Commission",E4="XG"),"B",""))

Open in new window

0
 
LVL 5

Expert Comment

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

Author Comment

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

Expert Comment

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


Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question