Pls Help Me!!

[davidtips]

In column C is my answer after calculation of A & B (in percetage).

How can I change all my positive(+) and negetive(-) value of percetage in this colunm to show positive value only?

Thanks!

davidiew

[Gordon]

"davidtips" <davidtips.1ska79_1122019545.5219@excelforum-nospam.com> wrote
in message news:davidtips.1ska79_1122019545.5219@excelforum-nospam.com...
>
> In column C is my answer after calculation of A & B (in percetage).
>
> How can I change all my positive(+) and negetive(-) value of percetage
> in this colunm to show positive value only?
>
> Thanks!
>
> davidiew
>

If this is a financial calculation, is it WISE to get rid of the negative
percentages?

[Bob Phillips]

=ABS(A+B)

or whatever calculation formula that you use.

--
HTH

Bob Phillips

"davidtips" <davidtips.1ska79_1122019545.5219@excelforum-nospam.com> wrote
in message news:davidtips.1ska79_1122019545.5219@excelforum-nospam.com...
>
> In column C is my answer after calculation of A & B (in percetage).
>
> How can I change all my positive(+) and negetive(-) value of percetage
> in this colunm to show positive value only?
>
> Thanks!
>
> davidiew
>
>
> --
> davidtips
> ------------------------------------------------------------------------
> davidtips's Profile:
http://www.excelforum.com/member.php...o&userid=19103
> View this thread: http://www.excelforum.com/showthread...hreadid=389290
>

[davidtips]

Thanks! it perfectly as i want.

davidiew

[Gordon]

"davidtips" <davidtips.1skiib_1122030323.6483@excelforum-nospam.com> wrote
in message news:davidtips.1skiib_1122030323.6483@excelforum-nospam.com...
>
> Thanks! it perfectly as i want.
>
> davidiew
>
>
> --
> davidtips

You may not be aware but you are actually posting to a public newsgroup. You
are very much in the minority by posting through this forum, so please
follow Usenet practice and quote the post you are replying to.

Thanks

[Bob Phillips]

"Gordon" <gordon@gbpcomputing.co.uk.invalid> wrote in message
news:uf6Rb7qjFHA.3656@TK2MSFTNGP09.phx.gbl...
> "davidtips" <davidtips.1skiib_1122030323.6483@excelforum-nospam.com> wrote
> in message news:davidtips.1skiib_1122030323.6483@excelforum-nospam.com...
> >
> > Thanks! it perfectly as i want.
> >
> > davidiew
> >
> >
> > --
> > davidtips
>
> You may not be aware but you are actually posting to a public newsgroup.
You
> are very much in the minority by posting through this forum, so please
> follow Usenet practice and quote the post you are replying to.

What?

[Dave Peterson]

I think Gordon reads the last post (or the earlier posts age off very quickly
for his newsreader).

He likes to see the original question and response when he reads these messages.



Bob Phillips wrote:
>
> "Gordon" <gordon@gbpcomputing.co.uk.invalid> wrote in message
> news:uf6Rb7qjFHA.3656@TK2MSFTNGP09.phx.gbl...
> > "davidtips" <davidtips.1skiib_1122030323.6483@excelforum-nospam.com> wrote
> > in message news:davidtips.1skiib_1122030323.6483@excelforum-nospam.com...
> > >
> > > Thanks! it perfectly as i want.
> > >
> > > davidiew
> > >
> > >
> > > --
> > > davidtips
> >
> > You may not be aware but you are actually posting to a public newsgroup.
> You
> > are very much in the minority by posting through this forum, so please
> > follow Usenet practice and quote the post you are replying to.
>
> What?

--

Dave Peterson

[Gordon]

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:42E0F188.D7662AC5@verizonXSPAM.net...
>I think Gordon reads the last post (or the earlier posts age off very
>quickly
> for his newsreader).
>
> He likes to see the original question and response when he reads these
> messages.
>
>
>

In reasonably high volume groups, I set my reader to Unread messages
only......otherwise I would be continually wading through huge numbers of
read posts in order to see the unread ones....and anyway, it's usenet
convention to quote the post(s) you are replying to.......