IF statement

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
JagwarmanAsked:
Who is Participating?
 
Shaun KlineConnect With a Mentor Lead Software EngineerCommented:
If you are looking for a formula solution, you can use:

=if(c4="commission", if(e4="vs", "c", if(e4="xg", "b", ""), ""), "")
0
 
indrajitmahajanCommented:
hi...

below URL should resolve your problem:

http://www.techonthenet.com/excel/formulas/if_nested.php
0
 
JagwarmanAuthor Commented:
indrajitmahajan unfortuantely that did not help me
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
JagwarmanAuthor Commented:
Shaun I took off the last two ""  and it works. Thanks

=if(c4="commission", if(e4="vs", "c", if(e4="xg", "b", "")))
0
 
Naresh PatelTraderCommented:
Try this
=IF(AND(C4="Commission",E4="VS"),"C",IF(AND(C4="Commission",E4="XG"),"B",""))

Open in new window

0
 
indrajitmahajanCommented:
Jagwarman thats fine.. more important is to get your solution :)
0
 
JagwarmanAuthor Commented:
itjockey that works too thanks. Sorry I can't give you any points as they already went
0
 
Naresh PatelTraderCommented:
I am not after points, I am learning every day    :)


Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.