Iam trying a lot to make the formula succes, but its not helping [Solved/Closed]

Report
Posts
1
Registration date
Friday November 15, 2013
Status
Member
Last seen
November 15, 2013
-
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
-
Hello Ther!!

Iam trying a lot to make the formula succes, but its not helping all people ther

Kindly help me on the below formula it gives result as false every time, i will be thankfull!!!!!



=IF(C17="2Z5",ACQUISITION,IF(C17=100,"RETIREMENTS",IF(C17="2Z0",TRANSFERS)))



regards
Syed

3 replies


OK. Good job for posting what you have already.

Let us take a look at what is happening.....
So if the logic statement is constructed of:
=if(logic_test,true,false)

.....then let us break your down and see what is happening....

=IF(C17="2Z5",ACQUISITION,IF(C17=100,"RETIREMENTS",IF(C17="2Z0",TRANSFERS)))


first logic
=if(c17="2Z5",{variable of acquisition},

Do you want to display "AQUISITION"? If so, then put quotations areound your text. ALL text is qualified in (programming) languages as TEXT. TEXT is identified by the Quotes {"}.

So lets just say you wanted to print the word "AQUISITION", it would look like this:
=if(c17="2Z5","AQUISITION",false)

Now let us break down the second logic that is nested in your statement, for the false check:
IF(C17=100,"RETIREMENTS")


So your logic would be :
=if(c17="2Z5","AQUISITION",IF(C17=100,"RETIREMENTS"),IF(C17="2Z0","Transfers"))


I have not tested, but nesting logic is acceptable. Just make certain to Qualify the text, and close logic tests [the )].
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Ohh my god, my problem is solved now!!!!!!!

hearty thanks to u, hope i can have your help in future also,,

Iam just a begginer in excel iam trying different things to save my job.

Thanks a lot!!!

god bless you.

Regards
Syed
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Don't waste your time with the IF, use the VLOOKUP instead, it is easier to maintain as well.