=IF(A2 >= D2, CONCATENATE("Sanctioned - days with pay(", A2, ")"),
CONCATENATE("Sanctioned - days without pay (", D2 - A2, ")"))On 3/30/13, Mukesh <[email protected]> wrote: > Hello Friends, > I have created a leave register and required a macro coding/formula to get > the appropriate remark in remark column. My query is as follows: > column ‘a2’ leave credited > column ‘d’ days required > column ‘f’ remark > > Result condition: > > If days required are > leave credited the remark should be: sanctioned – > days with pay (leave credited) and – days without pay (days required – leave > credited) > > Thank you. > > Regards > > Mukesh Baviskar > Mobile: 9403161157 > Skype id: mukeshbaviskar > Blog: > http://mukeshbaviskar.blogspot.com > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > -- Best Regards, Zujar... An optimist laughs to forget, whereas a pessimist forgets to laugh! Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
