How to apply number formatting to a Excel formula

[swamper8]

All, I have three formulas "&'d" together in a single cell.
These were previously in three separate cells right next to one another.
The first and third just show a text result. The 2nd (middle) formula calculates a numerical value based on what's in two other cells (J44 and E39)

The mathematical calculation is showing 10+ decimal places, I'd only like it to show two.
Both formula reference cells (E39/J44) are set to zero decimal places and I set the cell format this formula is in to "% with two decimal places" but neither fixed the issue.

Middle Formula that is calculating -0.0969953.... is shown below:

=F(J48="","",IF(($J$44-$E$39)/$E$39<-0.09,($J$44-$E$39)/E39,IF(($J$44-$E39)/$E$39>0.09,($J$44-$E$39)/E39,"")))

 

[johnnyL]

Try:
Round(($J$44-$E$39)/E39, 2)

 

[swamper8]

That worked well thank you. Once I got it rounded down I performed a x100 and /-1 to convert it to a positive whole number percentage. Thanks!

 

[johnnyL]

Your welcome @swamper8 .