Division % error

I am using this Formula (=SUM(A3-B3)/B3) to get the +/- % but every
time I have a 0 in either of the cells I get an error, how can I get
the correct calculation without errors.
Thanks
0
marc747 (8)
7/18/2008 9:32:57 PM
excel 39880 articles. 2 followers. Follow

10 Replies
457 Views

Similar Articles

[PageSpeed] 45

=IF(B3=0,0,(A3-B3)/B3)

no need to use sum here

-- 


Regards,


Peo Sjoblom

<marc747@excite.com> wrote in message 
news:1b99c8b4-1906-4d94-a91d-900e4e8fbe87@v1g2000pra.googlegroups.com...
>I am using this Formula (=SUM(A3-B3)/B3) to get the +/- % but every
> time I have a 0 in either of the cells I get an error, how can I get
> the correct calculation without errors.
> Thanks 


0
peo.sjoblom (169)
7/18/2008 9:49:55 PM
First of all, you didn't say what error you get, but it's likely a #DIV/0! error when B3 is 
zero.  Secondly, you don't really need the SUM() function.  Your formula could have been 
=(A3-B3)/B3.  Try this:

=IF(B3<>0,(A3-B3)/B3,"eh?")

Replace "eh?" with whatever you want to see when B3 is zero.  It could be 0, "" (for what 
looks like nothing), etc.

-- 
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
<marc747@excite.com> wrote in message 
news:1b99c8b4-1906-4d94-a91d-900e4e8fbe87@v1g2000pra.googlegroups.com...
>I am using this Formula (=SUM(A3-B3)/B3) to get the +/- % but every
> time I have a 0 in either of the cells I get an error, how can I get
> the correct calculation without errors.
> Thanks 


0
someone798 (945)
7/18/2008 9:51:40 PM
Thanks, Can you look below and see how I can Formulate so that I can
get the correct calaulation, I have a minus in cell "B3" and when I
and trying to get a percentage change I am getting "-1909.50% this has
to be a + number because first it is "-210" and then from "-210" we
have "3799.95 so the % has to be an increase.

    A           B           C
3799.95	-210  =3D  -1909.50% " =3D(A3-B3)/B3"

Thanks









On Jul 18, 2:51=A0pm, "Earl Kiosterud" <some...@nowhere.com> wrote:
> First of all, you didn't say what error you get, but it's likely a #DIV/0=
! error when B3 is
> zero. =A0Secondly, you don't really need the SUM() function. =A0Your form=
ula could have been
> =3D(A3-B3)/B3. =A0Try this:
>
> =3DIF(B3<>0,(A3-B3)/B3,"eh?")
>
> Replace "eh?" with whatever you want to see when B3 is zero. =A0It could =
be 0, "" (for what
> looks like nothing), etc.
>
> --
> Regards from Virginia Beach,
>
> Earl Kiosterudwww.smokeylake.com
> -----------------------------------------------------------------------<m=
arc...@excite.com> wrote in message
>
> news:1b99c8b4-1906-4d94-a91d-900e4e8fbe87@v1g2000pra.googlegroups.com...
>
>
>
> >I am using this Formula (=3DSUM(A3-B3)/B3) to get the +/- % but every
> > time I have a 0 in either of the cells I get an error, how can I get
> > the correct calculation without errors.
> > Thanks- Hide quoted text -
>
> - Show quoted text -

0
marc747 (8)
7/19/2008 12:28:53 AM
=IF(B3<>0,(B3-A3)/B3,"eh?")

Eh?

-- 
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
<marc747@excite.com> wrote in message 
news:962ed8d5-099c-4bf6-b5db-4f24ef3a41a3@u6g2000prc.googlegroups.com...
Thanks, Can you look below and see how I can Formulate so that I can
get the correct calaulation, I have a minus in cell "B3" and when I
and trying to get a percentage change I am getting "-1909.50% this has
to be a + number because first it is "-210" and then from "-210" we
have "3799.95 so the % has to be an increase.

    A           B           C
3799.95 -210  =  -1909.50% " =(A3-B3)/B3"

Thanks


On Jul 18, 2:51 pm, "Earl Kiosterud" <some...@nowhere.com> wrote:
> First of all, you didn't say what error you get, but it's likely a #DIV/0! error when B3 
> is
> zero. Secondly, you don't really need the SUM() function. Your formula could have been
> =(A3-B3)/B3. Try this:
>
> =IF(B3<>0,(A3-B3)/B3,"eh?")
>
> Replace "eh?" with whatever you want to see when B3 is zero. It could be 0, "" (for what
> looks like nothing), etc.
>
> --
> Regards from Virginia Beach,
>
> Earl Kiosterudwww.smokeylake.com
> -----------------------------------------------------------------------<marc...@excite.com> 
> wrote in message
>
> news:1b99c8b4-1906-4d94-a91d-900e4e8fbe87@v1g2000pra.googlegroups.com...

> >I am using this Formula (=SUM(A3-B3)/B3) to get the +/- % but every
> > time I have a 0 in either of the cells I get an error, how can I get
> > the correct calculation without errors.
> > Thanks- Hide quoted text -
>
> - Show quoted text -


0
someone798 (945)
7/19/2008 1:02:49 AM
On Jul 18, 5:28 pm, marc...@excite.com wrote:
> I have a minus in cell "B3" and when I and trying
> to get a percentage change I am getting "-1909.50%

Are you familiar the phrase "garbage in, garbage out"?

Your computation is correct, but the result might be meaningless
because you might not be using the correct computation for the
situation.

Unfortunately, you are not being very clear about the situation.  So
it is difficult to infer the best solution for you.

First, you need to understand that the formula (A3-B3)/B3 gives you
the percentage change from B3 to A3.  For example, if something cost
$100 (B3) last year and it costs $150 (A3) this year, the percentage
change is 50%.

Is that really what you have in A3 and B3?  Did the value start out at
-210, and it is now 3799.95(!)?  I doubt it.

Conversely, if you want to compute the percentage change from A3 to
B3, you would compute (B3-A3)/A3.  But I doubt that fits your
situation either.

Moreover, both formulas make sense only if the sign of A3 and B3 is
the same; that is, they are both positive, or they are both negative,
and the denominator is not zero.

My guess is:  3799.95 represents some value, and -210 represents the
change.  That is, the value went from 3799.95 to 3589.95.

If that's the case, the formula that you want is simply =3DB3/A3,
formatted as Percentage.  That will work when B3 is positive (increase
in value), too.

Hope that helps.  If not, please specify what the numbers in A3 and B3
represent.


----- original  posting -----

On Jul 18, 5:28=A0pm, marc...@excite.com wrote:
> Thanks, Can you look below and see how I can Formulate so that I can
> get the correct calaulation, I have a minus in cell "B3" and when I
> and trying to get a percentage change I am getting "-1909.50% this has
> to be a + number because first it is "-210" and then from "-210" we
> have "3799.95 so the % has to be an increase.
>
> =A0 =A0 A =A0 =A0 =A0 =A0 =A0 B =A0 =A0 =A0 =A0 =A0 C
> 3799.95 -210 =A0=3D =A0-1909.50% " =3D(A3-B3)/B3"
>
> Thanks
>
> On Jul 18, 2:51=A0pm, "Earl Kiosterud" <some...@nowhere.com> wrote:
>
>
>
> > First of all, you didn't say what error you get, but it's likely a #DIV=
/0! error when B3 is
> > zero. =A0Secondly, you don't really need the SUM() function. =A0Your fo=
rmula could have been
> > =3D(A3-B3)/B3. =A0Try this:
>
> > =3DIF(B3<>0,(A3-B3)/B3,"eh?")
>
> > Replace "eh?" with whatever you want to see when B3 is zero. =A0It coul=
d be 0, "" (for what
> > looks like nothing), etc.
>
> > --
> > Regards from Virginia Beach,
>
> > Earl Kiosterudwww.smokeylake.com
> > -----------------------------------------------------------------------=
<mar=ADc...@excite.com> wrote in message
>
> >news:1b99c8b4-1906-4d94-a91d-900e4e8fbe87@v1g2000pra.googlegroups.com...
>
> > >I am using this Formula (=3DSUM(A3-B3)/B3) to get the +/- % but every
> > > time I have a 0 in either of the cells I get an error, how can I get
> > > the correct calculation without errors.
> > > Thanks- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

0
joeu2004 (766)
7/19/2008 1:30:40 AM
Thanks, I am thinking maybe this is the way excel calculates!!!!

But I would like to try and see maybe there is a way to do it
correctly. I am giving you an example of how my numbers are!

(A) $3799.95 is sales for June 2008
(B) $-210 is sales for June 2007 (in this case it was a return item)
So in this case I would like to know in June 2008 how many +/- % is
it.

Thanks.







On Jul 18, 6:30=A0pm, joeu2004 <joeu2...@hotmail.com> wrote:
> On Jul 18, 5:28 pm, marc...@excite.com wrote:
>
> > I have a minus in cell "B3" and when I and trying
> > to get a percentage change I am getting "-1909.50%
>
> Are you familiar the phrase "garbage in, garbage out"?
>
> Your computation is correct, but the result might be meaningless
> because you might not be using the correct computation for the
> situation.
>
> Unfortunately, you are not being very clear about the situation. =A0So
> it is difficult to infer the best solution for you.
>
> First, you need to understand that the formula (A3-B3)/B3 gives you
> the percentage change from B3 to A3. =A0For example, if something cost
> $100 (B3) last year and it costs $150 (A3) this year, the percentage
> change is 50%.
>
> Is that really what you have in A3 and B3? =A0Did the value start out at
> -210, and it is now 3799.95(!)? =A0I doubt it.
>
> Conversely, if you want to compute the percentage change from A3 to
> B3, you would compute (B3-A3)/A3. =A0But I doubt that fits your
> situation either.
>
> Moreover, both formulas make sense only if the sign of A3 and B3 is
> the same; that is, they are both positive, or they are both negative,
> and the denominator is not zero.
>
> My guess is: =A03799.95 represents some value, and -210 represents the
> change. =A0That is, the value went from 3799.95 to 3589.95.
>
> If that's the case, the formula that you want is simply =3DB3/A3,
> formatted as Percentage. =A0That will work when B3 is positive (increase
> in value), too.
>
> Hope that helps. =A0If not, please specify what the numbers in A3 and B3
> represent.
>
> ----- original =A0posting -----
>
> On Jul 18, 5:28=A0pm, marc...@excite.com wrote:
>
>
>
> > Thanks, Can you look below and see how I can Formulate so that I can
> > get the correct calaulation, I have a minus in cell "B3" and when I
> > and trying to get a percentage change I am getting "-1909.50% this has
> > to be a + number because first it is "-210" and then from "-210" we
> > have "3799.95 so the % has to be an increase.
>
> > =A0 =A0 A =A0 =A0 =A0 =A0 =A0 B =A0 =A0 =A0 =A0 =A0 C
> > 3799.95 -210 =A0=3D =A0-1909.50% " =3D(A3-B3)/B3"
>
> > Thanks
>
> > On Jul 18, 2:51=A0pm, "Earl Kiosterud" <some...@nowhere.com> wrote:
>
> > > First of all, you didn't say what error you get, but it's likely a #D=
IV/0! error when B3 is
> > > zero. =A0Secondly, you don't really need the SUM() function. =A0Your =
formula could have been
> > > =3D(A3-B3)/B3. =A0Try this:
>
> > > =3DIF(B3<>0,(A3-B3)/B3,"eh?")
>
> > > Replace "eh?" with whatever you want to see when B3 is zero. =A0It co=
uld be 0, "" (for what
> > > looks like nothing), etc.
>
> > > --
> > > Regards from Virginia Beach,
>
> > > Earl Kiosterudwww.smokeylake.com
> > > ---------------------------------------------------------------------=
--<mar=AD=ADc...@excite.com> wrote in message
>
> > >news:1b99c8b4-1906-4d94-a91d-900e4e8fbe87@v1g2000pra.googlegroups.com.=
...
>
> > > >I am using this Formula (=3DSUM(A3-B3)/B3) to get the +/- % but ever=
y
> > > > time I have a 0 in either of the cells I get an error, how can I ge=
t
> > > > the correct calculation without errors.
> > > > Thanks- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

0
marc747 (8)
7/19/2008 4:50:57 AM
On Jul 18, 9:50=A0pm, marc...@excite.com wrote:
> Thanks, I am thinking maybe this is the way excel
> calculates!!!!

Excel does not calculate any particular "way".  You tell Excel how you
want something calculated, and Excel does it.  Whether or not the
calculation makes sense is entirely up to you.


> (A) $3799.95 is sales for June 2008
> (B) $-210 is sales for June 2007 [....]
> So in this case I would like to know in June 2008
> how many +/- % is it.

Okay, you do indeed have the right idea.  If the more-recent number
(2008) is in A3 and the older number (2007) is in B3, I think the
following formula will give you the result you desire:

=3DIF(B3=3D0, SIGN(A3), (A3-B3)/ABS(B3))

If the old number was zero, any positive change will be treated as
100%, and any negative change will be treated as -100%.  This is an
arbitrary choice.  There is no right answer.

Otherwise:

1. A change from -50 to 0 will be a 100% gain, and from -50 to 50 will
be a 200% change.  Likewise for 50 to 100 and 50 to 150.

2. A change from 50 to 0 will be a 100% loss (100%), and from 50 to
-50 will be a 200% loss (-200%).  Likewise for -50 to -100 and -50 to
-150.

In your case, a change from -210 to 3800 about a 1910% gain.
0
joeu2004 (766)
7/19/2008 5:52:45 AM
Errata....

On Jul 18, 10:52 pm, I wrote:
> If the old number was zero, any positive change will
> be treated as 100%, and any negative change will be
> treated as -100%.  This is an arbitrary choice.
> There is no right answer.

I mean there is no right __mathematical__ answer.  I don't know about
GAAP in the US or your jurisdiction.


----- original posting ------

On Jul 18, 10:52=A0pm, joeu2004 <joeu2...@hotmail.com> wrote:
> On Jul 18, 9:50=A0pm, marc...@excite.com wrote:
>
> > Thanks, I am thinking maybe this is the way excel
> > calculates!!!!
>
> Excel does not calculate any particular "way". =A0You tell Excel how you
> want something calculated, and Excel does it. =A0Whether or not the
> calculation makes sense is entirely up to you.
>
> > (A) $3799.95 is sales for June 2008
> > (B) $-210 is sales for June 2007 [....]
> > So in this case I would like to know in June 2008
> > how many +/- % is it.
>
> Okay, you do indeed have the right idea. =A0If the more-recent number
> (2008) is in A3 and the older number (2007) is in B3, I think the
> following formula will give you the result you desire:
>
> =3DIF(B3=3D0, SIGN(A3), (A3-B3)/ABS(B3))
>
> If the old number was zero, any positive change will be treated as
> 100%, and any negative change will be treated as -100%. =A0This is an
> arbitrary choice. =A0There is no right answer.
>
> Otherwise:
>
> 1. A change from -50 to 0 will be a 100% gain, and from -50 to 50 will
> be a 200% change. =A0Likewise for 50 to 100 and 50 to 150.
>
> 2. A change from 50 to 0 will be a 100% loss (100%), and from 50 to
> -50 will be a 200% loss (-200%). =A0Likewise for -50 to -100 and -50 to
> -150.
>
> In your case, a change from -210 to 3800 about a 1910% gain.

0
joeu2004 (766)
7/19/2008 6:21:37 AM
wow!!!  impressed, works great.
can you tell me what the "SIGN" and the "ABS" do in this formula.

thanks,





On Jul 18, 10:52=A0pm, joeu2004 <joeu2...@hotmail.com> wrote:
> On Jul 18, 9:50=A0pm, marc...@excite.com wrote:
>
> > Thanks, I am thinking maybe this is the way excel
> > calculates!!!!
>
> Excel does not calculate any particular "way". =A0You tell Excel how you
> want something calculated, and Excel does it. =A0Whether or not the
> calculation makes sense is entirely up to you.
>
> > (A) $3799.95 is sales for June 2008
> > (B) $-210 is sales for June 2007 [....]
> > So in this case I would like to know in June 2008
> > how many +/- % is it.
>
> Okay, you do indeed have the right idea. =A0If the more-recent number
> (2008) is in A3 and the older number (2007) is in B3, I think the
> following formula will give you the result you desire:
>
> =3DIF(B3=3D0, SIGN(A3), (A3-B3)/ABS(B3))
>
> If the old number was zero, any positive change will be treated as
> 100%, and any negative change will be treated as -100%. =A0This is an
> arbitrary choice. =A0There is no right answer.
>
> Otherwise:
>
> 1. A change from -50 to 0 will be a 100% gain, and from -50 to 50 will
> be a 200% change. =A0Likewise for 50 to 100 and 50 to 150.
>
> 2. A change from 50 to 0 will be a 100% loss (100%), and from 50 to
> -50 will be a 200% loss (-200%). =A0Likewise for -50 to -100 and -50 to
> -150.
>
> In your case, a change from -210 to 3800 about a 1910% gain.

0
marc747 (8)
7/19/2008 6:34:58 AM
On Jul 18, 11:34 pm, marc...@excite.com wrote:
> can you tell me what the "SIGN" and the "ABS"
> do in this formula.

SIGN() returns -1, 0 or 1 for negative, zero and positive numbers.
Note that 1 is 100%.

ABS() returns the magnitude or "absolute value" of a number; that is,
the number without its sign.  For example, ABS(-100) is 100, and
ABS(100) is also 100.

The formula works the way we think of percentage change intuitively.
The gain or loss is determined by the direction of change.  The
percentage is determined by the ratio of change over the magnitude of
the base value.

ERRATA....  I wrote:
> 2. A change from 50 to 0 will be a 100% loss (100%),
> and from 50 to -50 will be a 200% loss (-200%).

Obvious typo:  I should have written "(-100%)".


----- original posting -----

On Jul 18, 11:34=A0pm, marc...@excite.com wrote:
> wow!!! =A0impressed, works great.
> can you tell me what the "SIGN" and the "ABS" do in this formula.
>
> thanks,
>
> On Jul 18, 10:52=A0pm, joeu2004 <joeu2...@hotmail.com> wrote:
>
>
>
> > On Jul 18, 9:50=A0pm, marc...@excite.com wrote:
>
> > > Thanks, I am thinking maybe this is the way excel
> > > calculates!!!!
>
> > Excel does not calculate any particular "way". =A0You tell Excel how yo=
u
> > want something calculated, and Excel does it. =A0Whether or not the
> > calculation makes sense is entirely up to you.
>
> > > (A) $3799.95 is sales for June 2008
> > > (B) $-210 is sales for June 2007 [....]
> > > So in this case I would like to know in June 2008
> > > how many +/- % is it.
>
> > Okay, you do indeed have the right idea. =A0If the more-recent number
> > (2008) is in A3 and the older number (2007) is in B3, I think the
> > following formula will give you the result you desire:
>
> > =3DIF(B3=3D0, SIGN(A3), (A3-B3)/ABS(B3))
>
> > If the old number was zero, any positive change will be treated as
> > 100%, and any negative change will be treated as -100%. =A0This is an
> > arbitrary choice. =A0There is no right answer.
>
> > Otherwise:
>
> > 1. A change from -50 to 0 will be a 100% gain, and from -50 to 50 will
> > be a 200% change. =A0Likewise for 50 to 100 and 50 to 150.
>
> > 2. A change from 50 to 0 will be a 100% loss (100%), and from 50 to
> > -50 will be a 200% loss (-200%). =A0Likewise for -50 to -100 and -50 to
> > -150.
>
> > In your case, a change from -210 to 3800 about a 1910% gain.- Hide quot=
ed text -
>
> - Show quoted text -

0
joeu2004 (766)
7/19/2008 1:52:59 PM
Reply:

Similar Artilces:

error C2143: syntax error : missing ';' before '<'
I keep on getting this error..it points to this line ... const UnboundedSetByValue<Semester> getEnrolledSemesters() const; the line also produces his error error C2059: syntax error : '<' ...

Error on submitting timesheet
I have a resource that everyone they submit their timesheet an error occurs. It works fine for everyone else (about 200 people). They see on their screen "Timesheet lines were not added because at least one of them already exists" However he's not adding new lines.. in the logs here is what I see. ---- 1:37:13 PM /PWA: STEP 1 - Connect to PSI web services 1:37:13 PM /PWA: STEP 2 - Start event override for timesheet UID: b1af77a5-0bb5-4e65-9666-72398c0537ee 1:37:13 PM /PWA: STEP 3 - Statusing Impersonation for RES_UID: 777f1740-1df9-404c-9060-b8c61da78604 1:37...

A configuration error in e-mail system caused the message to bounc
Hi, The following error is returned to the sender of the message when they send a message to a server within our Exchange organisation which is down. This is obviously wrong as the message should be queued until the server is available again. "A configuration error in the e-mail system caused the message to bounce between two servers or to be forwarded between two recipients. Contact your administrator." Bizzarely, despite this, the message is still delivered successfully once the desitination server is back up. All of our Exchange servers are in the same routing group....

error (0x8004011D)
I am using microsoft outlook 2002 on a LAN fine, but when i take my laptop home to connect to the LAN exchange 5.5 fails to connect and I choose workoffline. As I try to send and receive mail exchange returns an error - (0x8004011D) The server is not available. Contact your administrator if this condition persists. How can I go round this problem. ...

mail delivery error #4
tcp/error occurred while trying to send data to the server. pop3 server error number 0x800ccc13. how do I correct error? Can, receive any mail. ...

Manufacturing outsource error
When creating a purchase order for outsourcing using a Manufacturing Order I get an error of "another user is editing this transaction". No one else is in the system and a new PO number is created each time. Has anyone else experienced this problem? -- Karla R Karla, Try going to Transactions > Manufacturing > Security, you are looking to see if a user is "hung" in that MO. If so, you should be able to delete that record and then perform your PO process. Please let me know if this doesn't work. -- Matt Wisner Interdyn-Prodata 405-840-0461 "K...

Calendar Error 0x80040216
Microsoft CRM Unhandled Error Details: Server Error in '/' Application. -------------------------------------------------------------------------------- Server was unable to process request. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Services.Protocols.SoapException: Server was unable to process request. Source Error: An unhandled exception was generated during the execution of the current web req...

division in access to round-up if division not whole number
when dividing a by b giving c; need to round-up c if it is not a whole number Excel has roundup but Access is devoid of this function. Round( a / b ) should give you what you need. That's actually Round( a / b, 0) where the number to the right of the comma is the number of decimals to round. As the helpfile in Access notes, if this is omitted, integers are returned. "ddiel" wrote: > when dividing a by b giving c; need to round-up c if it is not a whole number > Excel has roundup but Access is devoid of this function. "ddiel" <ddiel@discussio...

Error Message in Money2002
Since yesterday whenever I start Microsoft Money, I get an error message saying that there is no disk in the drive and I have an option to continue or cancel. While I am still able to access my money file and enter transactions this message pops up every time I change a screen. What should I do? Solomon solman1@comcast.net ...

Help on subscript out of range error (VB6/VBA)
Hi, I want to work with multiple excel workbooks en worksheets using a stand alone VB6 application. 1. First I open and close the workbooks and populate a listbox with sheetnames. 2. Then I select some sheets and fill an Array. (This array contains sheetnames from different workbooks) 3.The last step is to open and close the workbooks again and loop (For Each) through the sheets to get the information I need using the above mentioned array. The only problem is that I receive an "Subscript out of Range" error. This error occurs because I'm attempting tot access a worksheet...

Change Percentage DIV/0! Error
I'm trying to see the change between (A) 2002 unit sales and (B)200 unit sales, and am using the following formula: =(B-A)/A This gives me the difference negative or positive, however if A (200 sales) is zero, then I get the DIV/0! error, how do I fix this? Thank you -- Message posted from http://www.ExcelForum.com Hi, A couple of things you might want to consider. One is that your formula will not take into account what the change is if the prior month base amount is negative. To fix that use the =IF(base=0,"",(current-base)/ABS(base)) This should help >-----Or...

Need Error Number
Hi everyone! Using A02 on XP. Need to know what the error number is for this message: "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the indes, or redefine the index to permit duplicat entries and try again." I need to show a specific message instead of that one. Is there a directory for errors? How do I find a list? Thanks in advance for any help or advice! -- Bonnie W. Anderson Cincinnati, OH ...

Not mentioned error
I've got someting rather strange here, any suggestions are welcome. I created a webap with 1 page and 1 codebehind file and also a webservice with 1 asmx and codebehind file. From a button on a crmform, the webapp page is called, collects information from my webservice that collects information from the crm service and metadataservice. the webpage shows all the active users in the crm system in a checkboxlist control. The user can check some fields and hits send. The webpage creates a string with xml in and calls a methode from the webservice which creates a crmmail object saves i...

How to resolve fatal error LNK1168 error?
I have created an addin which after building generates a .dll file.But whenever i make some changes to the code & try to rebuild i always get the error Linking... LINK : fatal error LNK1168: cannot open Debug/Qmore_1.dll for writing Error executing link.exe. But after unchecking the addin in the Addins & Macro Files tab in Tools->Customize & then closing Visual Studio IDE & again restarting the IDE it builds fine. Can anyone suggest what is to be done to get rid of this error? priyanka.biswas2480@gmail.com wrote: : > Can anyone suggest what is to be done to get rid of ...

Error Sending Message on Behalf of Specified User
Hello, Small Business Server 2000 (Exchange 2000). A while back, I set up incoming faxes to be routed to a mailbox called Fax when using MS Shared Fax following the steps in KBase article 311529 (How to Configure the Shared Fax Service to Route Incoming Fax Jobs to a Common Inbox). I gave a Security Group called FaxAdmins "full mailbox access" to the Fax mailbox. Everything worked fine and the receptionists were able to log into the mailbox and forward the fax to the intended recipient. When I came in today, it no longer worked. Now, when the receptionist tries to forward the messa...

sbs 2008 console error
Good day, after the migration we have some problems with sbs 2008 console: we cannon't create the user with console. We can create with manual command. An exception of type 'Type: Microsoft.WindowsServerSolutions.Admin.Common.ADException, AdminCommon, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' has occurred. Timestamp: 03/09/2010 19:21:28 Message: La funzionalità Windows SBS Console non è stata configurata correttamente. Stack: in Microsoft.WindowsServerSolutions.Admin.Common.ProductADConstants.GetRolesDistinguishedName() ...

Convert Lead to Account produces an Error
I receive the following Error whe nattempting to convert a Lead to an Account. (See more Info at bottom of this post). Also - I can convert a newly created (test) Lead with no problem. ********************************** Microsoft CRM Platform Error Report: Error Description: Exception from HRESULT: 0x80042F09. Error Details: Details on this error have not been provided by the platform. Error Number: 0x80042F09 Source File: Not available Line Number: Not available Date: 04-26-2005 Time: 1:34:33 PM Type: Platform Error (2) Server: sbs.tiltrac.com ************************ More Inf...

Division help? #2
In MS Excel I would like to show a quotient in three separate columns such as 16/3 = 5 + 5 + 6. Can this be done? Please let me know a.s.a.p. I can't deduce the logic you are applying here. Can you post some more examples of what you want to input and how you would like the output to appear? Pete If you put 16 in A1, you can put this in B1: =int(a1/3) you can put this in C1: =b1 you can put this in D1: =a1-b1-c1 clayblay wrote: > > In MS Excel I would like to show a quotient in three separate columns such as > 16/3 = 5 + 5 + 6. Can this be done? Please let me know ...

Application Error
Cannot open Microsoft Monet 2002. I receive the following message: The Application failed to initialize properly (0xc0000005). Click on OK to terminate program. Have restarted computer several times and has not corrected problem. Until today (9/12) had not had any problems opening this software. Do I need to reinstall software? Thanks in advance for your help! Richard M. Fischer In microsoft.public.money, Richard M. Fischer wrote: >Cannot open Microsoft Monet 2002. I receive the following >message: The Application failed to initialize properly >(0xc0000005). Click on OK to...

Next TRX number error
I'm able to create a batch but once I try to calculate my batches I receive this error. Next TRX number in control file is invalid. Pleae verify the Next TRX number and try again. Is there a check in place I can do to fix this? Are you using the Canadian Payroll module? Look at Knowledgebase article #856366 "Richard" wrote: > I'm able to create a batch but once I try to calculate my batches I receive > this error. Next TRX number in control file is invalid. Pleae verify the Next > TRX number and try again. Is there a check in place I can do to fix this? Tha...

Errors in Portfolio Performance Calculations
There is a flaw in Microsoft Money’s evaluation of portfolio performance that can seriously mislead an unsavvy investor. The problem shows up in the calculation of “Total Return” (TR 4-Week, TR YTD, etc…). The problem shows up in the % shown on the Portfolio Manager. It shows up erroneously in “Portfolio Review” when comparing performance vs. S&P500 or other benchmarks. It also shows up in the % Rate of Return calculation in the Reports section for Investment performance. I’ll use an example. I have an old rollover IRA that began 2008 with ~$60,000 in assets. No money was tra...

errors and donwloading
Since loading IE8, most windows load with errors and windows does not recognize the signature (even thier own). -- Lost Cowboy ...

Linking error #3
Hi all , I am using the fillowing function to build the glut.dll .. int gettimeofday(struct timeval* tp, void* tzp) { struct timeb tb; ftime(&tb); tp->tv_sec = tb.time; tp->tv_usec = tb.millitm * 1000; /* 0 indicates that the call succeeded. */ return 0; } when i build the workspace i get the fillowing error >win32_util.obj : error LNK2019: unresolved external symbol __imp___ftime64@4 referenced in function _ftime@4 1>Debug/GLUT32.DLL : fatal error LNK1120: 1 unresolved externals Can you please help me to remove the errors. regards, Meenal have u included ti...

Division as a %
What am I doing wrong. example: 100 divided by 3 = a third which = 33.3%. Using =b2/c2 and cell formulated for % gives me 3333% I am not understanding this. ss schreef in news:NlSxq.47805$th7.9112@newsfe07.ams2 > What am I doing wrong. > example: > > 100 divided by 3 = a third which = 33.3%. > Using =b2/c2 and cell formulated for % gives me 3333% > > I am not understanding this. 100/3 = 33.33 = 3333%. -- Alex. On 19/11/2011 19:50, Alex Plantema wrote: > ss schreef in news:NlSxq.47805$th7.9112@newsfe07.ams2 > >> What am I doing wrong. >> example:...

Error on conversion to UNICODE
Hi I have a popup window in my application, similar to the MSN taskbar popup. I set its window text by loading it from the resource file (LoadString), and set a CString data member in its class. Everything works fine with MBCS character set but when I change the project settings to use the UNICODE character set, the text appears completely mangled. On debugging, I see that the text is being set correctly in the data member. But, when the window gradually pops up I see that the text consists of junk characters What am I doing wrong? Any special considerations that I need to take care of...