Thanks so much for this video. I got this to work however I am now having another issue. I am using this to calculate square footage. The issue is that if I have zero square footage to below line items once I'm done it now adds 1 to those zero's. I would like it not to round if square footage is zero. How can I do that? Is there a way to add and "except when 0" to the formula?
But if I have 1 column and I type in 1.35 and want it to automatically go to 2 how do I do that? You have 2 columns showing it. I want one column showing it.
How about i want to get the average of a rounded up values without considering it's decimals/ or actual values... Like i want it to calculate the average of 85 83 85 84 and not 85.1 83.4 84.9 84.3 Because in my experience excel will still consider the decimal which results in a different answer compared to when calculated manually
THANK YOU SO MUCH I CANNOT THANK YOU ENOUGH BECAUSE I SWEARR MY TEACHERS CANT TEACH AT ALLL YOU ARE SAVING MEEE!!!
You're literally building my career and excel expertise singlehandedly with your videos, god bless you!
Thank you for the clear, direct communication and results.
Exactly what I was looking for thank you for being straightforward.
legendddd. this worked straight away, thanks so much!
Simple, Clear, to the point. Thank you so much.
Great video! Thank you!
Awesome, Well Explained. Thank You. Understood.
That's quite good!!! Learning everyday from your video ❤
Many thanks for your great tutorial ❤
Thanks for the tutorial l completely understand now🎉
Thank you. I like the training
Thank you even the basic course taught me some new tricks, that's not easy being an old dog😂🤣
Very helpful. Love it
Thanks man, that was helpful
Excellent❤❤❤❤
Thanks big man
Thanka a lot man u saved my day😊
I AM first person THANKS for ever ❤❤❤ i love this channel
Love Excel!!! Great video
Thank you~!
Thanks a lot sir,,
thank you
Thanks so much for this video. I got this to work however I am now having another issue. I am using this to calculate square footage. The issue is that if I have zero square footage to below line items once I'm done it now adds 1 to those zero's. I would like it not to round if square footage is zero. How can I do that? Is there a way to add and "except when 0" to the formula?
But if I have 1 column and I type in 1.35 and want it to automatically go to 2 how do I do that? You have 2 columns showing it. I want one column showing it.
How about i want to get the average of a rounded up values without considering it's decimals/ or actual values...
Like i want it to calculate the average of
85 83 85 84 and not
85.1 83.4 84.9 84.3
Because in my experience excel will still consider the decimal which results in a different answer compared to when calculated manually
Thank you. I don.t understand the use of mround though
I often wondered how that could be done. Thank you! ☘🇮🇪🏡🐂🐮🧤🏁🌞☘
How to round down a negative amount?
👏👏👏👏
man i can sleep hearing your voice
I AGRÉE OMDSS HES GOOD AT TEACHING AND CAN MAKE ME FALL ASLEEP AHAHAH