ROUND AND SUM FUNCTION IN ONE FORMULA

[HighlandPiper]

Good afternoon, all

I have a spreadsheet with a sum function in K20 formatted for a percentage, which looks like this =SUM(K6:K19) and it returns a value of 16.13%

As well as displaying the total percentage I would also like to ROUND the figure to 0 decimal places. is it possible to combine a SUM function and a ROUND function together, if so how can I do this please?

Also, is it possible to add a round function to a cell when taking information from another worksheet such as this ='Template '!C47

 

[RoryA]

Assuming you want the percentage rounded to 0DP, that's actually rounding the sum to 2DP, so:

=ROUND(SUM(K6:K19),2)

 

[HighlandPiper]

Assuming you want the percentage rounded to 0DP, that's actually rounding the sum to 2DP, so:

=ROUND(SUM(K6:K19),2)

Hi Rory - there is no ROUND function applied at present it is just a SUM function with the formatting to 2 decimal places. I want to use a ROUND to 0DP. Thank you for the function, much appreciated. Could you also support with the ROUND function when the information is taken from a different sheet and how both link together please, i.e. how would I add the ROUND function to this formula?

='Template '!C47

 

[RoryA]

What I meant was that a percentage is in hundredths - eg 16.13% is actually the number 0.1613 so if you rounded the underlying value to 0DP you would get 0 which is of course also 0%. You need to round the value to 2DP (0.16 in this case) and then display as a percentage (16%)

It would be

=ROUND('Template '!C47,0)

for example

 

[HighlandPiper]

Excellent Rory! Thank you very much, greatly appreciated.