Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|