Omg!! This totally makes sense. The increase, decrease decimal option in Excel doesn't change the value AT ALL! That's why there's errors in my calculations when I use the calculator. THANK YOU SO MUCH!!
Thank you. Have been looking everywhere to figure out how to include a "round" function formula into another formula (maximum, minimum, average). This is exactly what I needed!
column a =140, column b=40% column c=answer, column d=round., is this possible? 140 * 40% = 56, to this 140 * 40% = 60, how to put a formula to automatic round? yes the 56 we can do it in separate column cell in columnd d like =round(c1,-1) the result is 60
I need your help. I tried your tutorial on my work & it didn't work....can you tell me what l should be doing ...... I need to make a cell round up when .005 or more & round down when .005 is less whilst a formula is already in the cell.... Does this make sense?
TLC4Sher, did you figure it out? Im trying to do ithat now, I need if the number is more than 4.10 it rounds up and if is 4.09 to round down, can you help me please
Omg!! This totally makes sense.
The increase, decrease decimal option in Excel doesn't change the value AT ALL!
That's why there's errors in my calculations when I use the calculator.
THANK YOU SO MUCH!!
This man, and his majestic excel voice, just saved my life.
Super helpful, thanks!
Thank you. Have been looking everywhere to figure out how to include a "round" function formula into another formula (maximum, minimum, average). This is exactly what I needed!
Ahhh!!! This is exactly what I was looking for! I couldn't figure out how to round using a formula and the function!
So helpful, thank you!
Thank you!
great tutorial!
Great info , many thanks
wow thanks
THANK YOU VERY MUCH, I AM SAVED TODAY!!! hehehe
Thank you
Unable to round down with a formula cell containing division. Need help..
@ TLC4Sher - I would try to use a multiplier, 200 in your case, round, then divide by the 200...
How do I do I want to round to only $1 or 50 cent?
how to round off to the previous 1000?
thanks .. i was confused
column a =140, column b=40% column c=answer, column d=round., is this possible? 140 * 40% = 56, to this 140 * 40% = 60, how to put a formula to automatic round? yes the 56 we can do it in separate column cell in columnd d like =round(c1,-1) the result is 60
Thankssssssssssssssssssss!
I need your help.
I tried your tutorial on my work & it didn't work....can you tell me what l should be doing
......
I need to make a cell round up when .005 or more & round down when .005 is less whilst a formula is already in the cell....
Does this make sense?
this comment was posted 7 years ago...wow
...... What should decrease desimall help me with...
its good :-)
TLC4Sher, did you figure it out? Im trying to do ithat now, I need if the number is more than 4.10 it rounds up and if is 4.09 to round down, can you help me please
+Noelle Contreras use IF >value roundup;+IF
Phone Booth movie ?
Very confusing...
maybe ur not a good listener lol
then how would I know it's confusing lmao
@@SharkRockstar aint it the point?
@@viixxxie guess you'll never know..
TO SLOW
speed it up lol
Robux
Your video is not clear
maybe ur not a good listener lol