Pls Help Me!!
 

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 :mad:


--
davidtips
------------------------------------------------------------------------
davidtips's Profile: http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=389290

"davidtips" wrote
in message ...

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 :mad:


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

=ABS(A+B)

or whatever calculation formula that you use.

--
HTH

Bob Phillips

"davidtips" wrote
in message ...

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 :mad:


--
davidtips
------------------------------------------------------------------------
davidtips's Profile:
http://www.excelforum.com/member.php...o&userid=19103
View this thread: http://www.excelforum.com/showthread...hreadid=389290

Thanks! it perfectly as i want.

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" wrote
in message ...

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

"Gordon" wrote in message
...
"davidtips" wrote
in message ...

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?

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" wrote in message
...
"davidtips" wrote
in message ...

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

"Dave Peterson" wrote in message
...
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.......