barbaracabeCopper ContributorJun 07, 2022Excel formula 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 positiv...Show More
HansVogelaarMVPJun 07, 2022barbaracabe =-TY/LY or perhaps =-TY/LY-1 Format the cell with the formula as a percentage.
