Excel formula

Copper Contributor

What is the correct formula for a P&L to compare the % up or down to LY.  My LY number is negative and TY is positive so it is showing a negative percentage compared to LY but obviously it is positive.  What do I need to do to the formula to make it show correctly?

1 Reply

@barbaracabe 

=-TY/LY

or perhaps

=-TY/LY-1

Format the cell with the formula as a percentage.