Hi Amit use below formula in C3
=IF(B3<=2,"0-2 Days",IF(B3<=7,"3-7 days",IF(B3<=14,"8-14 days",IF(B3<=30,"15-30 days","More than 30 days")))) Thanks Mahesh On Sat, Aug 20, 2011 at 10:53 AM, Amit Desai (MERU) <amit.de...@merucabs.com > wrote: > Thanks this helped…**** > > ** ** > > Now what if I need, TAT range (0 – 2 day, 3 – 7 days, etc…) next to > “Completion time in Days” column in the attached file?**** > > ** ** > > Best Regards,**** > > Amit Desai**** > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ashish koul > *Sent:* Saturday, August 20, 2011 9:54 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ TAT reporting for assignment**** > > ** ** > > see if it helps**** > > On Sat, Aug 20, 2011 at 9:21 AM, Amit Desai <amit...@gmail.com> wrote:**** > > Dear All,**** > > **** > > Need your help, to have a formula to get answers in yellow cells for # of > services completed in TAT in days.**** > > **** > > Sample sheet attached for your reference.**** > > **** > > Best Regards,**** > > Amit **** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > > > **** > > ** ** > > -- **** > > *Regards***** > > * ***** > > *Ashish Koul***** > > *akoul*.*blogspot*.com <http://akoul.blogspot.com/>* > http://akoul.posterous.com/***** > > *akoul*.wordpress.com <http://akoul.wordpress.com/>**** > > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>*** > * > > **** > > P Before printing, think about the environment.**** > > **** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > ------------------------------ > Disclaimer: This message and its attachments contain confidential > information and may also contain legally privileged information. This > message is intended solely for the named addressee. If you are not the > addressee indicated in this message (or authorized to receive for > addressee), you may not copy or deliver any part of this message or its > attachments to anyone or use any part of this message or its attachments. > Rather, you should permanently delete this message and its attachments (and > all copies) from your system and kindly notify the sender by reply e-mail. > Any content of this message and its attachments that does not relate to the > official business of Meru Cab Company Pvt. Ltd. must be taken not to have > been sent or endorsed by any of them. Email communications are not private > and no warranty is made that e-mail communications are timely, secure or > free from computer virus or other defect. > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
