Results 1 to 9 of 9
Thread: formula needed for excel

20160521, 15:32 #1
 Join Date
 Feb 2002
 Location
 Harrisburg, Pennsylvania, USA
 Posts
 168
 Thanks
 1
 Thanked 0 Times in 0 Posts
formula needed for excel
Hello All,
I have a need to solve for x
9,798 4.2% = x
6,813 4.2% = x
15,500 2.5% = x
10,908 1.9% = x
14,389 3.0% = x
8,950 4.3% = x
19,341 7.2% = x
12,82 10.6% = x
if the % is not showing it will be greater than 100 % to x ..(ie) 104.2%
is there a formula i can use down a column to achieve this goal?
Thank you for the help

20160521, 17:36 #2
 Join Date
 May 2016
 Posts
 50
 Thanks
 9
 Thanked 4 Times in 4 Posts
i'm not sure i follow what your meaning here

20160521, 17:47 #3
 Join Date
 Feb 2002
 Location
 Harrisburg, Pennsylvania, USA
 Posts
 168
 Thanks
 1
 Thanked 0 Times in 0 Posts
first column ... current sales % is growth or decline from last year ... I am trying to find out what last years sales dollars are.

20160521, 18:02 #4
 Join Date
 May 2016
 Posts
 50
 Thanks
 9
 Thanked 4 Times in 4 Posts
ahhhh, so
x is a dollar figure
and you basically want the percentage increase (or decrease) in a hard cash dollar figure
ok, be back in a bit

20160521, 18:14 #5
 Join Date
 Jan 2001
 Location
 La Jolla, CA
 Posts
 1,470
 Thanks
 30
 Thanked 62 Times in 58 Posts
If you want the line by line increase or decrease, first separate the data into two columns, then multiply.
If there's something else you're looking for, please indicate.
Note: your last number is missing a digit.
Clip0015.jpg
Or did you want the result of the increase or decrease?
Clip0017.jpgLast edited by kweaver; 20160521 at 18:20.

20160521, 18:31 #6
 Join Date
 Aug 2010
 Location
 Pa, USA
 Posts
 2,637
 Thanks
 115
 Thanked 650 Times in 592 Posts
cvbs,
In this example, enter the formula:
=A2/(100%+B2)
In cell C2 then copy down. Hope I understood you correctly,
Maud
CVBS.png

20160521, 18:32 #7
 Join Date
 May 2016
 Posts
 50
 Thanks
 9
 Thanked 4 Times in 4 Posts
ok, so, first figure is this years sales, and the percentage is the over or under last years totals, then to find last years totals, try what i have done in this workbook, it might help
The ROUND function can be specified to go up or down (ROUNDUP / ROUNDDOWN) without defining it, it goes to the closest 10 i think
Formula
Code:=ROUNDUP(A1(A1*B1%),2)
workbook with some formatting to tidy the cell display....Last edited by Gunslinger; 20160521 at 18:54.

20160521, 19:20 #8
 Join Date
 Jan 2001
 Location
 La Jolla, CA
 Posts
 1,470
 Thanks
 30
 Thanked 62 Times in 58 Posts
Maud, I was unclear if the OP wanted the increase/decrease as I did or what you did. Either way, the OP has the solution!

20160521, 22:27 #9
 Join Date
 Aug 2010
 Location
 Pa, USA
 Posts
 2,637
 Thanks
 115
 Thanked 650 Times in 592 Posts
Kw,
I was unclear to me as well. But having a dilemma looked at from different angles often offers many creative solutions.
Maud