Psostive value
 

Hi Folks..

I have a simple percentage formula as....
=(A2-A1)/A1%
=(B2-A1)/A1%
and so on...
Sometimes the answer comes to negative percentage when the value in A2 0r B2
is lesser than A1..
All i need is always have a posotive value for the same.. Any formula?
Also if there is something that can keep A1 as constant in both places in
formula by only changing the first cell i.e. A2 or B2, it can be really
helpfull.

.....Thanks....

Psostive value
 

... All i need is always have a positive value for the same
.. Any formula?

Think you can try ABS(...)
Example, in A3: =ABS((A2-A1)/A1)
with A3 formatted as percentage to taste
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---

Psostive value
 

Thanks Max.... Really.... I didn't know it was that simple....
However could you help me to keep the cell A1 as constant because i have to
take [ercentage of many cells.....

"Max" wrote:

... All i need is always have a positive value for the same
.. Any formula?

Think you can try ABS(...)
Example, in A3: =ABS((A2-A1)/A1)
with A3 formatted as percentage to taste
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---

Psostive value
 

"K****ij" wrote:
Thanks Max.... Really.... I didn't know it was that simple....

Welcome. Pl mark that response by pressing the "Yes" button (like the ones
below)

However could you help me to keep the cell A1 as constant because i have to
take percentage of many cells.....

I suppose you mean "fix" cell A1 so that it doesn't change as you copy the
formula across/down? This is done through using the dollar signs ($) on the
cell ref, eg: $A$1

So going by the earlier you could have in A3: =ABS((A2-$A$1)/$A$1)
Then when you drag to copy A3 across, the pointing to cell A1 will not
change, but the "A2" will change to B2, C2, etc

Alternatively you could have in B2: =ABS((A2-$A$1)/$A$1)
When you drag to copy B2 down, the pointing to cell A1 will not change, but
the "A2" will change to A3, A4, etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---

Psostive value
 

thanks Again.... Well again that was simple.....

"Max" wrote:

"K****ij" wrote:
Thanks Max.... Really.... I didn't know it was that simple....

Welcome. Pl mark that response by pressing the "Yes" button (like the ones
below)

However could you help me to keep the cell A1 as constant because i have to
take percentage of many cells.....

I suppose you mean "fix" cell A1 so that it doesn't change as you copy the
formula across/down? This is done through using the dollar signs ($) on the
cell ref, eg: $A$1

So going by the earlier you could have in A3: =ABS((A2-$A$1)/$A$1)
Then when you drag to copy A3 across, the pointing to cell A1 will not
change, but the "A2" will change to B2, C2, etc

Alternatively you could have in B2: =ABS((A2-$A$1)/$A$1)
When you drag to copy B2 down, the pointing to cell A1 will not change, but
the "A2" will change to A3, A4, etc
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---

Psostive value
 

Welcome, but pl press the Yes button below, won't you?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
"K****ij" wrote:
thanks Again.... Well again that was simple.....