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

20160521, 14:32 #1
 Join Date
 Feb 2002
 Location
 Harrisburg, Pennsylvania, USA
 Posts
 170
 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, 16: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, 16:47 #3
 Join Date
 Feb 2002
 Location
 Harrisburg, Pennsylvania, USA
 Posts
 170
 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, 17: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, 17:14 #5
 Join Date
 Jan 2001
 Location
 La Jolla, CA
 Posts
 1,559
 Thanks
 43
 Thanked 72 Times in 68 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 17:20.

20160521, 17:31 #6
 Join Date
 Aug 2010
 Location
 Pa, USA
 Posts
 2,881
 Thanks
 147
 Thanked 732 Times in 664 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, 17: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 17:54.

20160521, 18:20 #8
 Join Date
 Jan 2001
 Location
 La Jolla, CA
 Posts
 1,559
 Thanks
 43
 Thanked 72 Times in 68 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, 21:27 #9
 Join Date
 Aug 2010
 Location
 Pa, USA
 Posts
 2,881
 Thanks
 147
 Thanked 732 Times in 664 Posts
Kw,
I was unclear to me as well. But having a dilemma looked at from different angles often offers many creative solutions.
Maud