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
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Nov 17, 2013 at 02:02 AM
Related:
- Iam trying a lot to make the formula succes, but its not helping
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
3 responses
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 )].
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
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
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.
