[FREE Excel Course] Lesson 11 - Math Formulas in Excel
Vložit
- čas přidán 7. 05. 2019
- In this video of this Free Excel Training, you will learn about the MATH formulas
-- INT function
-- MOD function
-- RAND function
-- RANDBETWEEN function
- ROUND function
-- SUM function
-- SUMIF function
-- SUMIFS function
-- SUMPRODUCT function
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com/learn-excel/
You can also access the Full Excel Training on CZcams here: • Getting Started with E...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: czcams.com/users/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
![[FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel](http://i.ytimg.com/vi/qo5N8wR3rz8/mqdefault.jpg)
![[FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel](/img/tr.png)
This free course is gem on CZcams....
this is still relevant in 2024, love the playlist
thank you, you gem
Thank you for the kind words Khushi... Happy to know you're finding the videos helpful 🙂
Hi Sumit.. thanks for the review of these useful MATH formulas and for sharing this video series for free. Thumbs up!
Your way if explaining is very Simple and Evey easy to understand.
Much appreciated
thank you some much, very clear and well explained!
Thanks for the this course.
I thought if it was difficult but you made it very simple.
Excellent videos. You have done a great job. You just need to add some practice sheets - this will help users to brush up on skills. thanks agaih
Thank you very much sir ❤️
Thanks. Sir 🙏🙏
Hi sumit, Thanks for sharing such valuable knowledge.
I would like know where such rand and randbetween function can be used.
it can be used for randomly taking out samples from the whole sheet
I think it would mostly be used by CA (auditors) as they have to check whether the infomation provided by client is correct or not
It is used for generating Random Numbers
It is used by Auditors for sampling purpose
For example suppose one client has 10000 sales invoices in a year
But A CA will not Audit all the sales invoice
He will Audit them on sample basis by using these formula to generate random number of invoice
Also companies when they have to give coupons ❤️gift vouchers to random customers they use these formula
IN SUMIF can we use the condition if the number is strikerthrough then it should sum other than it?
Hi sumit,Thank you so much for the free Tutorials on Excel.
Could please help me out, when i'm practicing sumifs with the same data used in the formulas. The answer or result for not equal to Tom is not the same as yours which is 200. Its showing 1100 instead. Thank you thank you so much in advance
Hi Sam! Have you figured it out? I could help you recheck your work if you want to.
I'm not Sumit (nor sent by Sumit 😂); I'm a student like you who's trying to learn Excel recently, and I believe lending someone a hand would help me practice my troubleshooting skills too. It would be a win-win for both of us.
Great
Thanks videos are very useful
for any confusion in the formula =round(605.55,2)
refer this Given the number 605.55 and the instruction to round to the nearest multiple of 100 (because of the "-2" specified):
Identify the digit position to which we're rounding. In this case, it's the hundreds place because of the "-2".
Look at the digit in the hundreds place. In 605.55, the digit in the hundreds place is 0.
Look at the digit to the right of the hundreds place. In 605.55, the digit to the right of the hundreds place is 5.
If the digit to the right of the rounding position is 5 or greater, we round up; otherwise, we round down.
Since the digit to the right of the hundreds place is 5, we round up.
So, 605.55 rounded to the nearest multiple of 100 is 600.
if I use ("*j*) as criteria and in the criteria range it contains like this(jpp,kj)so do these 2 values fulfill the criteria of ("*j*") or not?if yes,then does it mean that if * can be equal to 0 as well?
Yes it will fulfill
can I use randbetween to even return decimals?
let's say randombetween(1,5) and the result now for example 4.532
is it possible?
Hi IT Giants! Yes, it is. I found a workaround for your question from this website: www.techonthenet.com/excel/formulas/rand.php
Here's the general formula to obtain a random number with decimals using a specified range:
=RAND() * (max - min) + min
And here's the formula that answers your problem:
=RAND() * (5 - 1) + 1
You may adjust the decimal formatting based on your needs.
Hope this helps!
-Iver
Ker ke dakh le
Sir please check
=MOD(24,5) ans is 4 and =MOD(24,-5) ans is -1 How come?
Because it has negative divisor
what if i want to make more than one static cell
6:25
DO WE HAVE TO LEARN ALL THIS?
Whilen I try Sumifs it show 0
DO WE HAVE TO LEARN ALL THIS?
It's your choice😂
But bhaiya me use kaha hote h koi idea to dedo
I am not able to understand the ROUND function in -1, -3. Please can some one explain it in a little more detail.
Other than that everything is perfect.
Thank you sir.
The ROUND function in Excel follows the rounding rules based on the number of decimal places specified as the second argument. When the decimal place argument is negative, Excel rounds the number to the left of the decimal point.
In this case, with ROUND(550.55, -2), we want to round the number 550.55 to the nearest hundred. Since the decimal place argument is -2, we want to round to the left of the decimal point, specifically to the nearest hundred.
To perform this rounding, Excel considers the digit at the hundredth place, which is 5. According to the rounding rules, when the digit at the rounding position is 5 or greater, it rounds up. Since 5 is greater than 4, the number is rounded up to the nearest hundred, resulting in 600.
Therefore, the result of ROUND(550.55, -2) in Excel is 600.
hi
Someone tell me why this is important
anyone kow the answer to my question
DO WE HAVE TO L;EARN ALL THIS
?
not understandable