No video
Avoid Mistakes while Rounding Numbers in Google Sheets
Рет қаралды 871
Күн бұрын
@GM085 10 ай бұрын
I use mround when working with numbers formatted as fractions in food recipes. It's good when scaling the recipe up or down. Example: mround(A1,1/16)
@ProlificOaktree 10 ай бұрын
Whoa. I never thought about that. Thanks for sharing.
@user-tq2lr4uh3l 6 ай бұрын
thanks for sharing this tip. i have been pulling my hair out trying to use autosum to do calculations but the value is always wrong. It gets worse when I do division / multiplication and I cant manually remove the decimal points one by one. ROUND formula works and I just learnt it today. Thanks for the video!
@ProlificOaktree 6 ай бұрын
Glad it helped!
@melstj89 6 ай бұрын
Hello! In your initial example: 2+2 = 3, how do you get the sum to be 4? (i am adding 2 types of Taxes that were rounded, but the sum is off by $0.01)
@ProlificOaktree 5 ай бұрын
You can use the ROUND function. sheetshelp.com/round
@motherbarbelo7 10 ай бұрын
How can I skipping cells when entering data in google sheets
@ProlificOaktree 10 ай бұрын
Hold down the control key and hit the arrow.
Charisma on Command
Рет қаралды 23 МЛН
FREENVESTING
Рет қаралды 17 МЛН
The Knowledge Project Podcast
Рет қаралды 488 М.