# Thread: formula needed for excel

1. ## 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

3. first column ... current sales % is growth or decline from last year ... I am trying to find out what last years sales dollars are.

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

5. 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.jpg

6. cvbs,

In this example, enter the formula:

=A2/(100%+B2)

In cell C2 then copy down. Hope I understood you correctly,

Maud

CVBS.png

7. 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)`
EDIT: you don't have to use the round function, a very similar affect can be managed with the cell formatting, in fact, i think the workbook i posted with the tidied up formats may very well suffice, meaning the formula could be reduced to =A1-(A1*B1%)

workbook with some formatting to tidy the cell display....

8. 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!

9. Kw,

I was unclear to me as well. But having a dilemma looked at from different angles often offers many creative solutions.

Maud

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•