incorporate the remove #DIV/0! code into another formula to get bl

hi there, i have this formula below, and i somehow want to incorporate this 
=IFERROR(B1/C1,"") into it with the purpose of having the cell display 
nothing instead of #DIV/0! so that the column of data can then allow an index 
and match formula to work as it won't if any of the cells have #DIV/0! in 
them, any suggestion?

=(SUMIF($B$2:$B$2500,">=" & T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">=" &
(T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">=" &
T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & (T58+
TIMEVALUE("1:00")),$D$2:$D$2500))


-- 
thanks
0
Morgan (35)
10/28/2009 11:10:01 PM
excel.newusers 15348 articles. 2 followers. Follow

5 Replies
693 Views

Similar Articles

[PageSpeed] 25

What version of Excel are you using?

The portion of the formula that will cause the #DIV/0! error is when this 
evaluates to 0:

(SUMIF($B$2:$B$2500,">=" &T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & 
(T58+TIMEVALUE("1:00")),$D$2:$D$2500))

That can result in 0 for 2 reasons:

Either there are no time entries that meet the criteria  or,

There are time entries that meet the criteria but the values (if any) sum to 
0.

-- 
Biff
Microsoft Excel MVP


"Morgan" <Morgan@discussions.microsoft.com> wrote in message 
news:C59909A8-0650-4101-ACDD-2CEDCCE38014@microsoft.com...
> hi there, i have this formula below, and i somehow want to incorporate 
> this
> =IFERROR(B1/C1,"") into it with the purpose of having the cell display
> nothing instead of #DIV/0! so that the column of data can then allow an 
> index
> and match formula to work as it won't if any of the cells have #DIV/0! in
> them, any suggestion?
>
> =(SUMIF($B$2:$B$2500,">=" & T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">=" &
> (T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">=" &
> T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & (T58+
> TIMEVALUE("1:00")),$D$2:$D$2500))
>
>
> -- 
> thanks 


0
biffinpitt (3172)
10/29/2009 1:26:19 AM
hi, i'm using excel2007 and at the moment there are no time entries, but 
eventually they will fill up, i want to use an index and match formula 
similar to this =INDEX(P43:P54,MATCH(MAX(R43:R54),R43:R54,0))  which is 
dependent on there being no #DIV/0! errors, since it will be a while till the 
cells fill up with data, i was wondering if the #DIV/0! can be removed so the 
index and match formula will work?

thanks
-- 
thanks


"T. Valko" wrote:

> What version of Excel are you using?
> 
> The portion of the formula that will cause the #DIV/0! error is when this 
> evaluates to 0:
> 
> (SUMIF($B$2:$B$2500,">=" &T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & 
> (T58+TIMEVALUE("1:00")),$D$2:$D$2500))
> 
> That can result in 0 for 2 reasons:
> 
> Either there are no time entries that meet the criteria  or,
> 
> There are time entries that meet the criteria but the values (if any) sum to 
> 0.
> 
> -- 
> Biff
> Microsoft Excel MVP
> 
> 
> "Morgan" <Morgan@discussions.microsoft.com> wrote in message 
> news:C59909A8-0650-4101-ACDD-2CEDCCE38014@microsoft.com...
> > hi there, i have this formula below, and i somehow want to incorporate 
> > this
> > =IFERROR(B1/C1,"") into it with the purpose of having the cell display
> > nothing instead of #DIV/0! so that the column of data can then allow an 
> > index
> > and match formula to work as it won't if any of the cells have #DIV/0! in
> > them, any suggestion?
> >
> > =(SUMIF($B$2:$B$2500,">=" & T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">=" &
> > (T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">=" &
> > T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & (T58+
> > TIMEVALUE("1:00")),$D$2:$D$2500))
> >
> >
> > -- 
> > thanks 
> 
> 
> .
> 
0
Morgan (35)
10/29/2009 3:09:02 AM
>i'm using excel2007

Ok, that makes things a lot easier!

Just put your formula inside the IFERROR function:

=IFERROR((SUMIF($B$2:$B$2500,">="&T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">="&(T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">="&T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">="&(T58+TIMEVALUE("1:00")),$D$2:$D$2500)),"")

-- 
Biff
Microsoft Excel MVP


"Morgan" <Morgan@discussions.microsoft.com> wrote in message 
news:09143227-7894-4E9C-A72C-A6B54BD81329@microsoft.com...
> hi, i'm using excel2007 and at the moment there are no time entries, but
> eventually they will fill up, i want to use an index and match formula
> similar to this =INDEX(P43:P54,MATCH(MAX(R43:R54),R43:R54,0))  which is
> dependent on there being no #DIV/0! errors, since it will be a while till 
> the
> cells fill up with data, i was wondering if the #DIV/0! can be removed so 
> the
> index and match formula will work?
>
> thanks
> -- 
> thanks
>
>
> "T. Valko" wrote:
>
>> What version of Excel are you using?
>>
>> The portion of the formula that will cause the #DIV/0! error is when this
>> evaluates to 0:
>>
>> (SUMIF($B$2:$B$2500,">=" &T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" &
>> (T58+TIMEVALUE("1:00")),$D$2:$D$2500))
>>
>> That can result in 0 for 2 reasons:
>>
>> Either there are no time entries that meet the criteria  or,
>>
>> There are time entries that meet the criteria but the values (if any) sum 
>> to
>> 0.
>>
>> -- 
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Morgan" <Morgan@discussions.microsoft.com> wrote in message
>> news:C59909A8-0650-4101-ACDD-2CEDCCE38014@microsoft.com...
>> > hi there, i have this formula below, and i somehow want to incorporate
>> > this
>> > =IFERROR(B1/C1,"") into it with the purpose of having the cell display
>> > nothing instead of #DIV/0! so that the column of data can then allow an
>> > index
>> > and match formula to work as it won't if any of the cells have #DIV/0! 
>> > in
>> > them, any suggestion?
>> >
>> > =(SUMIF($B$2:$B$2500,">=" & T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">=" &
>> > (T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">=" &
>> > T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & (T58+
>> > TIMEVALUE("1:00")),$D$2:$D$2500))
>> >
>> >
>> > -- 
>> > thanks
>>
>>
>> .
>> 


0
biffinpitt (3172)
10/29/2009 3:26:11 AM
that was so simple, lol, thank you for your help! cheers



"T. Valko" wrote:

> >i'm using excel2007
> 
> Ok, that makes things a lot easier!
> 
> Just put your formula inside the IFERROR function:
> 
> =IFERROR((SUMIF($B$2:$B$2500,">="&T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">="&(T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">="&T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">="&(T58+TIMEVALUE("1:00")),$D$2:$D$2500)),"")
> 
> -- 
> Biff
> Microsoft Excel MVP
> 
> 
> "Morgan" <Morgan@discussions.microsoft.com> wrote in message 
> news:09143227-7894-4E9C-A72C-A6B54BD81329@microsoft.com...
> > hi, i'm using excel2007 and at the moment there are no time entries, but
> > eventually they will fill up, i want to use an index and match formula
> > similar to this =INDEX(P43:P54,MATCH(MAX(R43:R54),R43:R54,0))  which is
> > dependent on there being no #DIV/0! errors, since it will be a while till 
> > the
> > cells fill up with data, i was wondering if the #DIV/0! can be removed so 
> > the
> > index and match formula will work?
> >
> > thanks
> > -- 
> > thanks
> >
> >
> > "T. Valko" wrote:
> >
> >> What version of Excel are you using?
> >>
> >> The portion of the formula that will cause the #DIV/0! error is when this
> >> evaluates to 0:
> >>
> >> (SUMIF($B$2:$B$2500,">=" &T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" &
> >> (T58+TIMEVALUE("1:00")),$D$2:$D$2500))
> >>
> >> That can result in 0 for 2 reasons:
> >>
> >> Either there are no time entries that meet the criteria  or,
> >>
> >> There are time entries that meet the criteria but the values (if any) sum 
> >> to
> >> 0.
> >>
> >> -- 
> >> Biff
> >> Microsoft Excel MVP
> >>
> >>
> >> "Morgan" <Morgan@discussions.microsoft.com> wrote in message
> >> news:C59909A8-0650-4101-ACDD-2CEDCCE38014@microsoft.com...
> >> > hi there, i have this formula below, and i somehow want to incorporate
> >> > this
> >> > =IFERROR(B1/C1,"") into it with the purpose of having the cell display
> >> > nothing instead of #DIV/0! so that the column of data can then allow an
> >> > index
> >> > and match formula to work as it won't if any of the cells have #DIV/0! 
> >> > in
> >> > them, any suggestion?
> >> >
> >> > =(SUMIF($B$2:$B$2500,">=" & T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">=" &
> >> > (T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">=" &
> >> > T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & (T58+
> >> > TIMEVALUE("1:00")),$D$2:$D$2500))
> >> >
> >> >
> >> > -- 
> >> > thanks
> >>
> >>
> >> .
> >> 
> 
> 
> .
> 
0
Morgan (35)
10/29/2009 4:07:01 AM
You're welcome. Thanks for the feedback!

-- 
Biff
Microsoft Excel MVP


"Morgan" <Morgan@discussions.microsoft.com> wrote in message 
news:725AB498-5C06-4D75-B723-7B411B3632A6@microsoft.com...
> that was so simple, lol, thank you for your help! cheers
>
>
>
> "T. Valko" wrote:
>
>> >i'm using excel2007
>>
>> Ok, that makes things a lot easier!
>>
>> Just put your formula inside the IFERROR function:
>>
>> =IFERROR((SUMIF($B$2:$B$2500,">="&T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">="&(T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">="&T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">="&(T58+TIMEVALUE("1:00")),$D$2:$D$2500)),"")
>>
>> -- 
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "Morgan" <Morgan@discussions.microsoft.com> wrote in message
>> news:09143227-7894-4E9C-A72C-A6B54BD81329@microsoft.com...
>> > hi, i'm using excel2007 and at the moment there are no time entries, 
>> > but
>> > eventually they will fill up, i want to use an index and match formula
>> > similar to this =INDEX(P43:P54,MATCH(MAX(R43:R54),R43:R54,0))  which is
>> > dependent on there being no #DIV/0! errors, since it will be a while 
>> > till
>> > the
>> > cells fill up with data, i was wondering if the #DIV/0! can be removed 
>> > so
>> > the
>> > index and match formula will work?
>> >
>> > thanks
>> > -- 
>> > thanks
>> >
>> >
>> > "T. Valko" wrote:
>> >
>> >> What version of Excel are you using?
>> >>
>> >> The portion of the formula that will cause the #DIV/0! error is when 
>> >> this
>> >> evaluates to 0:
>> >>
>> >> (SUMIF($B$2:$B$2500,">=" &T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" &
>> >> (T58+TIMEVALUE("1:00")),$D$2:$D$2500))
>> >>
>> >> That can result in 0 for 2 reasons:
>> >>
>> >> Either there are no time entries that meet the criteria  or,
>> >>
>> >> There are time entries that meet the criteria but the values (if any) 
>> >> sum
>> >> to
>> >> 0.
>> >>
>> >> -- 
>> >> Biff
>> >> Microsoft Excel MVP
>> >>
>> >>
>> >> "Morgan" <Morgan@discussions.microsoft.com> wrote in message
>> >> news:C59909A8-0650-4101-ACDD-2CEDCCE38014@microsoft.com...
>> >> > hi there, i have this formula below, and i somehow want to 
>> >> > incorporate
>> >> > this
>> >> > =IFERROR(B1/C1,"") into it with the purpose of having the cell 
>> >> > display
>> >> > nothing instead of #DIV/0! so that the column of data can then allow 
>> >> > an
>> >> > index
>> >> > and match formula to work as it won't if any of the cells have 
>> >> > #DIV/0!
>> >> > in
>> >> > them, any suggestion?
>> >> >
>> >> > =(SUMIF($B$2:$B$2500,">=" & 
>> >> > T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,">=" &
>> >> > (T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,">=" &
>> >> > T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,">=" & (T58+
>> >> > TIMEVALUE("1:00")),$D$2:$D$2500))
>> >> >
>> >> >
>> >> > -- 
>> >> > thanks
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>> 


0
biffinpitt (3172)
10/29/2009 4:48:49 AM
Reply:

Similar Artilces:

Getting Excel Cell Address..
How do I get the cell address of an excel sheet from C#? VBA =Address(4, 5) would return "$E$4" Not able to find an equivalent function when processing the excel sheet from C#. Thanks in advance for all the help. are you trying to formulate formulas into the spreadsheet? whatever function you can access via vba, you can access the same way using office interop regardless vb.net or c# - if you don`t need the formula in the spreadsheet but just need to display the value in spreadsheet or if you are just using your 2 dimensional array to set value into the spreads...

Compiling problem (MSVC6.0)
I have a project that used to compile in a few seconds. It still does in Debug mode. But in Release mode, now it gets stuck: Class1.cpp Class2.cpp Class3.cpp Generating Code... And it will generate code her for say 5mins, before moving to the next file. Why has this suddenly started happening? Might I have a corrupt file? > I have a project that used to compile in a few seconds. It still does > in Debug mode. But in Release mode, now it gets stuck: > > Class1.cpp > Class2.cpp > Class3.cpp > Generating Code... > > And it will generate code her for say 5mins, befor...

How to remove all styles from the Quick Style Gallery
Word 2007 SP1 XP Pro SP2 Problem: How to remove all styles from the Quick Style Gallery I have many styles in the Quick Style Gallery list. I would like to have only a few listed. Is there a way to quickly remove all the styles in the Quick Style Gallery list instead of having to remove each style individually using the context menu? Thanks in advance. To clear all quick styles in the active document, you can run the following macro: Sub ClearAllQuickStylesInDoc() Dim s As Style For Each s In ActiveDocument.Styles If s.Type = wdStyleTypeCharacter Or _ ...

Command button
[Excel 2003] I have a listbox on a userform which displays the computers name : YOUR-X9X9X9X9 Is there a way to have a command button check this code against a string within the command button code which will do the following 1) if the code matches, a second userform :Userform2 is shown 2) if the code doesnt match a warning is shown and the command button doesnt open the second userform Can anyone help? Thanks, Roger Hi there, The principle is exactly the same as in your other post. Something along these lines: Function MayProceed() As Boolean Const ...

Any other formula to add 6mth to a given dates..
I had a column of dates and would like to use a formula to determine th next dates which is 6 month away. I tried using =workday(A1,C1), wher A1 to A50 is a series of date and C1 is 180(6mths), but the result giv me more than 6 mths. I had tried using =date(2006,4+6,15) but i had to many dates to key that. I understand that Excel function of "workdays and "Networkingday" refer to 5 days week. Is there any formula o function that I can use for 6 months for a equipment that is workin 24/7 basis, Excel don't support this -- Stephen -------------------------------------------...

Still getting Macro Security Warning Message after removing Macro
Excel 2002 SP3 Win XP Pro SP2 Hi, I had a macro in a spreadsheet which I ended up not needing. I removed it by going to VB Editor and removing the module containing the macro. However, I am STILL getting the Macro Security Warning when opening up the spreadsheet. How do I get rid of the warning? Or Could there be any trace of the macro left causing this warning? When going to View Macros (Alt+F8) that is blank/empty. Thanks. Go into the VBE once more (Alt-F11) and check if Modules is showing in the Project Explorer Window. If so, then right-click on the module and click on Remove M...

Removed Information Service
I deleted my personal folder option in the information service to try and recreate a problem a user had. Does any one know how to return it short of reinstalling office? Can't you just click "Add" on the list of services and re-add Personal Folders File? What version of Outlook? -- Aloha, -Ben- Ben M. Schorr, OneNote-MVP http://home.hawaii.rr.com/schorr **I apologize but I am unable to respond to direct requests for assistance. Please post questions and replies here in the newsgroup. Mahalo! "Felix" <anonymous@discussions.microsoft.com> wrote in message...

How do I remove margin tick marks?
I have these L-shapred "tick marks" for the lack of a better term, appearing at all four corners of my screen where the margin begins. They are in gray like gridlines, but I am not sure how to remove them. Can anyone help? Thanks! See this article: Margin marks or crop marks appear on each corner of the page when you open a document in Word http://support.microsoft.com/kb/839371/en-us -- Stefan Blom Microsoft Word MVP "Susan" <Susan@discussions.microsoft.com> wrote in message news:7DAC2173-B20B-436F-8938-0E6C45BA1A55@microsoft.com... >...

Removing time from a date field
There is a date column in my excel spreadsheet. The data in this column has both date and time. I want to strip off the time part using VBA. Please let me know if there is an elegant way to do this. advTHANKSance, Kirubakaran. www.kirubakaran.com I found the answer. I used the INT function. Change the format to date -- Don Guillett SalesAid Software donaldb@281.com "kulalosai" <kirubakaran@gmail.com> wrote in message news:1115658705.112166.113400@o13g2000cwo.googlegroups.com... > There is a date column in my excel spreadsheet. The data in this column > has both da...

Perhaps another Money alternative?
After years of their saying "what's Windows?" I not that the following announcement: --- Announcement: GnuCash 2.1.1 Release - 2007-04-28 17:47 GnuCash 2.1.1 released The GnuCash development team proudly announces GnuCash 2.1.1 aka "Bug-begone", the second of several unstable 2.1.x releases of the GnuCash Open Source Accounting Software which will eventually lead to the stable version 2.2.0. With this new release series, GnuCash is available on Microsoft Windows for the first time... --- I haven't checked into this further just yet, but that will certainly be...

Relinking Tables with VBA code
Hello together, I got this wonderful code from the internet to relink all tables from a backend database in the same folder. Unfortunatelly its not working: The code gets me the right folder (see MsgBox (strPath) but after that it links only the first table but not the others. Can anybody tell me what's wrong in the code? Thank you very much!!! Andreas Function link() On Error GoTo MyError Dim db As DAO.Database Dim strPath As String Dim i As Integer Set db = CurrentDb() strPath = Left(db.Name, Len(db.Name) - Len(Dir(db.Name))) & "social_performance...

How to incorporate voice commands into a VB6 application on XP?
On my new PC, which is running XP, I have been playing around with speech recognition. How can I get my VB6 program to respond to voice commands? VC works with, say, Word straight away. I don't have to configure XP or install anything. I just rand through a couple of the training exercises and then I could dictate into Word or switch to Voice Command mode and say things like "file open". I once experimented with Microsoft DirectSpeech in VB6, but I had to download a ton of SAPI stuff first. Ideally, I would not want a user to have to install anything other than wh...

Formula for deleting "
Hi, I have imported a CVS file delimited on commas. I got "" in beging and end along with numeric data in each cell. Data is in more than 1000 rows with 10 columns. I want to remove these commas and change the cell format to numeric without lossing any numerical data. Thanks in advance. Hi have you tried 'Edit - Replace' for this operation?. You may also have a look at: http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Regards Frank Kabel Frankfurt, Germany Dalvi wrote: > Hi, > > I have imported a CVS file delimited on commas. > I got "&quo...

Retrieving data from another workbook (path?)
Happy Saturday! Please can anyone help. I've done the searches and can't find an clues...I think maybe my question is just too simple.... I am getting a macro to password protect a worksheet with a password i a specif cell in another open workbook. The code: ActiveSheet.Protect Password:=Sheets("sheet1").Range("a1").Value ....works perfectly for inputting the password from within the sam workbook, but I'm blowed if I can find the code for referencing specific cell in a different open workbook. Logic tells me it should be ActiveSheet.Protec Password:...

Excel formula reference book recommendation
If anyone has any recommendations on a good reference book for excel relating to formulas, please let me know. If you are reasonably proficient with Excel then look no further than John Walkenbach's 'Excel Formulas 2002/3' http://www.amazon.com/exec/obidos/ASIN/0764540734/qid=1089914089/sr=2-1/ref=sr_2_1/103-7964776-0182256 http://www.amazon.com/exec/obidos/ASIN/076454800X/qid=1089914089/sr=2-2/ref=sr_2_2/103-7964776-0182256 -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -----------------------...

GET FILENAME WITHOUT EXTENSION
hi i've this macro string for write a filename (that i select) in a cell without the extension. In this case the filename remove only the 3 letters of extension. I need a macro that remove more long extension (filename. how i can modify this? Sub test() Dim FName As Variant Dim wb As Workbook Dim MyPath As String Dim SaveDriveDir As String Dim filename As String SaveDriveDir = CurDir MyPath = "C:\" ChDrive MyPath ChDir MyPath FName = Application.GetOpenFilename(filefilter:= _ "Pictures(*.jpg;*.gif;*.bmp), *.jpg;*.gif;*.bmp")...

Removing a window's frames does not remove it from the scrollbar
I have a dialog box with a tree control that will automatically holds a scrollbar. In the dialog's OnInitDialog I load the tree with so much content that the tree automatically creates a vertical scrollbar. I want to remove the tree's frame, but when I do the frame is removed from everything except the scrollbar. It isn't until I move the mouse over the scrollbar (causing it to highlight) or force the bar to scroll that the frame will disappear. I have tried invalidating and repainting the tree but that does not help. I have even dragged the dialog box offscreen and pull...

Removing server from routing group
Hello all I have an exchange 2003 server that is a part of its own domain and forest, but this exchange server is in our exchange routing group. I want to unsintall exchange from this server, but in order to do this i have to turn the system on, when i turn the box on it creates routing issues within our routing group. I want to know if its possible to remove this server from the routing grouo if the server is off line. Thanks ...

Removing watermarks form Word2003
edI have been through I think all the posted problems and answers and I seem to a have a new manifestation of a watermark (picture) that refuses to disappear! I inserted a watermark and resection the document. Some how the watermark down sized itself so is actually of no benefit. I have tried the "remove watermark" approach in format background but it doesn't actually see it? So then the no fill approach and searched headers and footers for any marks or anchors, zilch, nada, nothing. I found some strange achors possibly related to drawings in the document so re...

Usage of CRM 3.0
Hi all: Is there any obligation by downloading the beta? I mean, I am willing to download it , but only to play a little bit with it, to understand the internal (SQL) structures, because I have customers with CRM. But nothing else (by now). Any ideas? Thank you for your time (and patience with me) -- Alejandro Leguizamo SQL Server MVP Colombia www.solidqualitylearning.com ___________________________________ Hi Alejandro, You can download MSCRM v3.0 for testing purposes. You cannot use this version for production implementations (key is only valid for 90 days). In case you do fi...

Formula so that response is >value
The same cell has two formulas, IF(D3>0,LOG(C3/F3),IF(D3<1,LOG(C3/10)). For example, if C3 is 1.0E+06, D3 is 100, then F3 will be 1.0E+03 (due to another formula), and the response for the first part should read 3.0. If D3 is 0, F3 will be <10 (due to another formula), and the response should read >5.0, not simply 5.0. I'm not sure I follow your formulas as described, but if you're looking to have your results display the ">" character along with the value, then maybe this example will lead you in the right direction: Let's say cell A1 contains ...

Formula to format selective part in a text
Hi all, In MS Excel, in th below formula what additional formula do I add to make selective text in different formats (ex. bold)? Ex: ="Mission 1 Start Date: "&text(A1,"DD-MMM-YYYY") In the result I want only the date part of the result text to be in bold letters. Thanks in advance. No can do in a FORMULA. You must convert to a string -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "Gladiator" <Gladiator@discussions.microsoft.com> wrote in message news:7E825FD9-C276-43CF-BFB4-A7F3D6FB932E@microsoft.com.....

query returns no records, need to convert to "0"
my query returns no records, but i need it to be a zero value because that answer is used in a report that totals several items. Without a number (0), the totals won't work. If the report is based on a query that returns no records, and you have a text box in the report footer that is bound to an expression like this: =Sum([Amount]) it displays #Error. If you want to show a zero instead, change the expression to: =IIf([Report].[HasData], Sum([Amount]), 0) More information: Avoid #Error in form/report with no records at: http://allenbrowne.com/RecordCountError.html -...

How do I permanently remove deleted e-mails from my inbox? they h.
I delete messages in my inbox, a line is placed through them, but they never go away! how do I clear them permanently. I am running Outlook on Office xp. PLEASE HELP!! IMAP connection? Edit-> Purge Deleted Items... -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "bhmdorf" <bhmdorf@discussions.microsoft.com> wrote in message news:E32010C0-224A-45C9-A3CA-E9AAB7965C70@microsoft.com... >I delete messages in my inbox, a line is placed through the...

how to get elements of DistributionList by c#
hi all. i want to get elements of DistributionList by C# with Outlook 2007. i had name of DistributionList and i like to get all elements of DistributionList with that name. what should i do?? thanks for your help -- khoick245 "khoick245" <khoick245@yahoo.com> wrote in message news:khoick245.5ee9f1b@outlookbanter.com... > hi all. i want to get elements of DistributionList by C# with Outlook > 2007. i had name of DistributionList and i like to get all elements of > DistributionList with that name. what should i do?? thanks for your > help ...