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?
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
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.
You're literally building my career and excel expertise singlehandedly with your videos, god bless you!
THANK YOU SO MUCH I CANNOT THANK YOU ENOUGH BECAUSE I SWEARR MY TEACHERS CANT TEACH AT ALLL YOU ARE SAVING MEEE!!!
Thank you for the clear, direct communication and results.
Exactly what I was looking for thank you for being straightforward.
Awesome, Well Explained. Thank You. Understood.
That's quite good!!! Learning everyday from your video ❤
legendddd. this worked straight away, thanks so much!
Simple, Clear, to the point. Thank you so much.
Many thanks for your great tutorial ❤
Thank you even the basic course taught me some new tricks, that's not easy being an old dog😂🤣
Great video! Thank you!
Thank you. I like the training
Thanks man, that was helpful
Thanka a lot man u saved my day😊
Very helpful. Love it
Love Excel!!! Great video
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?
thank you
Thanks a lot sir,,
Thank you~!
Thank you. I don.t understand the use of mround though
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
I AM first person THANKS for ever ❤❤❤ i love this channel
I often wondered how that could be done. Thank you! ☘🇮🇪🏡🐂🐮🧤🏁🌞☘
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 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