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,"")))
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,"")))