(Msg. 1) Posted: Mon Sep 17, 2007 11:38 am
Post subject: Getting #DIV/0!, how to get 0%? Archived from groups: microsoft>public>excel>misc (more info?)
I'm getting #DIV/0! with the following formula, the cell is format as a
percent. Thanks
=(E34-D34)/E34
E34 = 0
D34 = 0
Result should be 0%
(Msg. 2) Posted: Mon Sep 17, 2007 11:42 am
Post subject: RE: Getting #DIV/0!, how to get 0%? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Check e34 prior to dividing.
if(e34 = 0, 0,(E34-D34)/E34)
--
HTH...
Jim Thomlinson
"pgarcia" wrote:
> I'm getting #DIV/0! with the following formula, the cell is format as a
> percent. Thanks
>
> =(E34-D34)/E34
> E34 = 0
> D34 = 0
> Result should be 0%
(Msg. 3) Posted: Mon Sep 17, 2007 11:42 am
Post subject: Re: Getting #DIV/0!, how to get 0%? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=IF(E34=0,0,(E34-D34)/E34)
--
Regards,
Peo Sjoblom
"pgarcia" <pgarcia.TakeThisOut@discussions.microsoft.com> wrote in message
news:F777B88C-63AF-4202-8F40-6218195C2EE1@microsoft.com...
> I'm getting #DIV/0! with the following formula, the cell is format as a
> percent. Thanks
>
> =(E34-D34)/E34
> E34 = 0
> D34 = 0
> Result should be 0%
(Msg. 4) Posted: Mon Sep 17, 2007 12:25 pm
Post subject: Re: Getting #DIV/0!, how to get 0%? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
thanks
"Peo Sjoblom" wrote:
> =IF(E34=0,0,(E34-D34)/E34)
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
> "pgarcia" <pgarcia.TakeThisOut@discussions.microsoft.com> wrote in message
> news:F777B88C-63AF-4202-8F40-6218195C2EE1@microsoft.com...
> > I'm getting #DIV/0! with the following formula, the cell is format as a
> > percent. Thanks
> >
> > =(E34-D34)/E34
> > E34 = 0
> > D34 = 0
> > Result should be 0%
>
>
>
(Msg. 5) Posted: Mon Sep 17, 2007 12:25 pm
Post subject: RE: Getting #DIV/0!, how to get 0%? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
thanks
"Jim Thomlinson" wrote:
> Check e34 prior to dividing.
>
> if(e34 = 0, 0,(E34-D34)/E34)
> --
> HTH...
>
> Jim Thomlinson
>
>
> "pgarcia" wrote:
>
> > I'm getting #DIV/0! with the following formula, the cell is format as a
> > percent. Thanks
> >
> > =(E34-D34)/E34
> > E34 = 0
> > D34 = 0
> > Result should be 0%
(Msg. 6) Posted: Mon Sep 17, 2007 2:48 pm
Post subject: Re: Getting #DIV/0!, how to get 0%? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Try it like this:
=IF(E34=0,0,(E34-D34)/E34)
--
Biff
Microsoft Excel MVP
"pgarcia" <pgarcia.RemoveThis@discussions.microsoft.com> wrote in message
news:F777B88C-63AF-4202-8F40-6218195C2EE1@microsoft.com...
> I'm getting #DIV/0! with the following formula, the cell is format as a
> percent. Thanks
>
> =(E34-D34)/E34
> E34 = 0
> D34 = 0
> Result should be 0%
(Msg. 7) Posted: Mon Sep 17, 2007 2:48 pm
Post subject: Re: Getting #DIV/0!, how to get 0%? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
thanks
"T. Valko" wrote:
> Try it like this:
>
> =IF(E34=0,0,(E34-D34)/E34)
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "pgarcia" <pgarcia RemoveThis @discussions.microsoft.com> wrote in message
> news:F777B88C-63AF-4202-8F40-6218195C2EE1@microsoft.com...
> > I'm getting #DIV/0! with the following formula, the cell is format as a
> > percent. Thanks
> >
> > =(E34-D34)/E34
> > E34 = 0
> > D34 = 0
> > Result should be 0%
>
>
>
(Msg. 8) Posted: Mon Sep 17, 2007 6:03 pm
Post subject: Re: Getting #DIV/0!, how to get 0%? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Although I don't like Excel 2007....
=IFERROR((E34-D34)/E34,0)
--
Dana DeLouis
"pgarcia" <pgarcia.DeleteThis@discussions.microsoft.com> wrote in message
news:F777B88C-63AF-4202-8F40-6218195C2EE1@microsoft.com...
> I'm getting #DIV/0! with the following formula, the cell is format as a
> percent. Thanks
>
> =(E34-D34)/E34
> E34 = 0
> D34 = 0
> Result should be 0%
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2, 3, 4
Page 1 of 4
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office