Turning a value into a percentage!
 

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

Turning a value into a percentage!
 

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.

"Dobbin0_4" wrote in message
...
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