Turning a value into a percentage!

D

Dobbin0_4

Ok so it's Sunday morning and i can't for the life of me remember how to turn
a value in to a percentage.

So heres the plan

the figure projected Sales (O4) - Actual sales (P4) = Difference % (Q4)
How do i turn the figure returned in Q4 in to a percentage and make it
absolute!

Real Brain fade!!!

Thanks
 
F

Fred Smith

Percentage difference is:

=(Projected - Actual) / Projected

Format as %.

If you want to make it absolute (although I can't figure out any reason
why), use:

=abs((projected - actual) / projected)

The problem with this formula is you would never know if you were above or
below the projection.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top