# Iam trying a lot to make the formula succes, but its not helping

Solved/Closed
luqmansyed Posts 1 Registration date Friday November 15, 2013 Status Member Last seen November 15, 2013 - Nov 15, 2013 at 03:07 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Nov 17, 2013 at 02:02 AM
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
Related:

## 3 responses

Blocked Profile
Nov 15, 2013 at 05:56 PM
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 )].
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
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Nov 17, 2013 at 02:02 AM
Don't waste your time with the IF, use the VLOOKUP instead, it is easier to maintain as well.