Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am not able to understand the round function.
When I used round(78.32,1,1) it gave me 100
but when I used round(78.32,0.01) it gave me 78. Can anyone please explain this?
Here is an explanation of the function
Hi, I placed =round(78.32,1,1) into a text box and it displayed 78. I am unsure of what is wrong.
You must be doing something else also, for example rounding in a second step on the Numbers tab. The Round() function does not work like you describe. See picture below
HIC
I am not sure but I guess since it's a percentage that's why I was getting the issue.
Hi,
in the number tab use the option "Expression default" and then let the round function do the rest, so your number is expressed correctly,
regards
Thank you everyone. It worked