We help IT Professionals succeed at work.

Sum Required

Simonrepro
Simonrepro asked
on
Hi,

In the attached spreadsheet shows cells C28 to I28 representing how much sales have gone up or down.  Now in cell c5 I would like a sum which takes my sales figure for this years april ie 500 (B4) and uses last years percentage to show me if i repeat the percentage what me sales figure would now be.

Kind Regards
Simon
Book1.xls
Comment
Watch Question

Business Analyst
CERTIFIED EXPERT
Commented:
I think what you're asking for could be done by using this formula in C5.

=(C28 + 1) * B4
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

try in C5

=B4+(C28*B4)

Do you want this formula refers to the actual sales data of the last month, so if no actual data has been entered yet, it will show 0

cheers, teylyn
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
If you want to project the same sales differences for the whole period, you can use this in C6

=C5+(D28*C5)

copy right. This will show data even if no actual sales have been entered in row 4. Note that C5 and C6 are different formulas.

cheers,

Commented:
Is that percentage an increase over the value in B4, or is it a difference?  I mean, does 50% equate to $750, or does it equate to $250?

If it's a straight difference, then the formula for C4 would be:
=$B4*C28
and you would just copy that formula into the adjacent cells.

If it's an increase over B4, it'd be:
=$B4+$B4*C28


If it's a difference or increase from the previous month, you would remove the "$" before the B.

Author

Commented:
Great Thanks!
Barry TiceBusiness Analyst
CERTIFIED EXPERT

Commented:
Looks like I was just in time!

Thanks, Simon. Glad to help!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.