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" 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


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


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