Reducing Decimal Places within an equation

[rcocrane99]

So the short answer is I can do it another way and completely disregard this buttt.... Is there any way to reduce my % to only be 1 decimal place given my equation.
This formula is probably over complicated as I can make just another cell and then have it be a percent and just add/remove decimal places that way but I thought this was a fun way to work around it. Mainly looking at the purple text for that last section for %.

Thanks!!

=IF(SUMIFS('Ga Metal Tracker'!$D:$D,'Ga Metal Tracker'!$B:$B,"Primary EW",'Ga Metal Tracker'!$E:$E,A3)=0,"",SUMIFS('Ga Metal Tracker'!$D:$D,'Ga Metal Tracker'!$B:$B,"Primary EW",'Ga Metal Tracker'!$E:$E,A3))&" kgs or "&(SUMIFS('Ga Metal Tracker'!$D:$D,'Ga Metal Tracker'!$B:$B,"Primary EW",'Ga Metal Tracker'!$E:$E,A3)/K3)*100&"%"

 

[Joe4]

I think you just need to add the ROUND function into your equation, i.e.
change this part:

&(SUMIFS('Ga Metal Tracker'!$D:$D,'Ga Metal Tracker'!$B:$B,"Primary EW",'Ga Metal Tracker'!$E:$E,A3)/K3)*100&"%"

to this:

&ROUND((SUMIFS('Ga Metal Tracker'!$D:$D,'Ga Metal Tracker'!$B:$B,"Primary EW",'Ga Metal Tracker'!$E:$E,A3)/K3),3)*100&"%"

 

[rcocrane99]

I think you just need to add the ROUND function into your equation, i.e.
change this part:

&(SUMIFS('Ga Metal Tracker'!$D:$D,'Ga Metal Tracker'!$B:$B,"Primary EW",'Ga Metal Tracker'!$E:$E,A3)/K3)*100&"%"

to this:

&ROUND((SUMIFS('Ga Metal Tracker'!$D:$D,'Ga Metal Tracker'!$B:$B,"Primary EW",'Ga Metal Tracker'!$E:$E,A3)/K3),3)*100&"%"

Aha! I knew there was something! Thanks!

 

[Joe4]

You are welcome!