Sam, You understood my problem correctly. I think rather using IF, I think we should try for scenario. I don't know much about this. My conditions are as follows.
1) PL are applicable after 1yr service. 2) Whoever already completed 1yr he/she will get full PL 3) If somebody finishing his 12months between the leave card duration should get PL with request to Pro-rata basis Regards, Suyog On Sunday, 13 January 2013 12:11:20 UTC+5:30, SamJesseK wrote: > > Suyog, > > It seems that multiple conditions can be met based on certain dates. Can > you double check the variables? The conditions must be independent of each > other for a multiple IF statement to be valid. > > On Sunday, January 13, 2013 1:17:56 AM UTC-5, Suyog Kulkarni wrote: >> >> Hello All, >> >> Requesting to help again. I.ve tried IF condition to solve this problem >> but failed. I don.t know how to create conditions with multiple If. >> >> With Regards, >> Suyog >> >> -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.