Dear Rajasekhar, You can use the IsError function as follows:
=IF(ISERROR(B4/C4),0,B4/C4) On Thu, Mar 8, 2012 at 12:31 AM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > i just used this formula however how can i add iserror formula to this.. > > > > > On Thu, Mar 8, 2012 at 12:29 AM, Rajasekhar Praharaju < > rajasekhar.prahar...@gmail.com> wrote: > >> thanks one and all for your help.......... >> >> >> On Wed, Mar 7, 2012 at 7:14 PM, dguillett1 <dguille...@gmail.com> wrote: >> >>> You didn’t show us your situation but, depending on your need you >>> could use LOOKUP, vLookup >>> >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Ashish Bhalara <ashishbhalar...@gmail.com> >>> *Sent:* Tuesday, March 06, 2012 10:14 PM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re: $$Excel-Macros$$ Need if formula >>> >>> Dear expert, >>> >>> If function used maximum 7 time in an function, if the requirement of >>> condition if is more than 7, what is the function used or which type of >>> condition are need to fulfill 10 different condition? >>> >>> Thanks & regards >>> >>> Ashish Bhalara >>> >>> On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta < >>> sharadgupta_2...@rediffmail.com> wrote: >>> >>>> >>>> >>>> On Tue, 06 Mar 2012 14:42:54 +0530 wrote >>>> >>>> >hi Experts, >>>> please provide if condition formula for attached sheet. >>>> Thanks,Rekah >>>> >>>> >>>> >>>> -- >>>> > >>>> FORUM RULES (986+ members already BANNED for violation) >>>> > >>>> >>>> > >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> > >>>> >>>> > >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> > >>>> >>>> > >>>> >>>> ------------------------------------------------------------------------------------------------------ >>>> > >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> > >>>> >>>> >>>> Sharad Gupta >>>> 9799795367 >>>> >>>> <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?> >>>> Follow >>>> *Rediff Deal ho >>>> jaye!<http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___&cmp=signature&lnk=rediffmailsignature&newservice=deals> >>>> * to get exciting offers in your city everyday. >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> ------------------------------------------------------------------------------------------------------ >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> >> >> -- >> -- >> Thanks & Regards, >> Rajasekhar.P >> >> Subscribe to our group and receive daily updates. >> Excel groups >> >> https://sites.google.com/site/excelencyclopedia/how-to-join/assignments >> >> Send your queries and Suggestions @ >> excel-gro...@googglegroups.com >> >> Excelforum Blogspot >> >> <a href=" >> http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US<http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US>">Subscribe >> to excel forum by Email</a> >> >> >> >> > > > -- > -- > Thanks & Regards, > Rajasekhar.P > > Subscribe to our group and receive daily updates. > Excel groups > > https://sites.google.com/site/excelencyclopedia/how-to-join/assignments > > Send your queries and Suggestions @ > excel-gro...@googglegroups.com > > Excelforum Blogspot > > <a href=" > http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US<http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US>">Subscribe > to excel forum by Email</a> > > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Thanks & regards, Noorain Ansari ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
