Excel MOD Function – Easy Explanation & Practical Examples of MOD for Work



Written Instructions & Workbook Download:

Simplest explanation of Excel’s MOD formula and how it can be used to solve real businesses cases. It explains the MOD function in simple terms and shows you three different practical cases.

Excel MOD is shown as follows:
1. Grouping participants into groups of 6, 3 or 4. Which is better? i.e. has less people left over.
2. Reporting quarterly data
3. Controlling the occurrences of data labels in charts. For example, you have a line series and you’d like to show the data label for every 2nd, 3rd or 4th occurrence.

Some details about MOD:
What does the MOD function do? By definition, it returns the remainder after one number is divided by another.

We can classify whole numbers into certain groups. For example, Odd and Even, or numbers that are divisible by two, by three, four, and so on. This is what the MOD function does. It checks if a number is divisible by another number and if not, how far away is it from being divisible. The key here, is that MOD looks backwards – i.e. to the next smaller number that was divisible and then count. MOD works the same with negative numbers. The video gives an example.

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free

EXCEL RESOURCES I Recommend:

Nguồn: https://tongcucthuevietnam.com

Xem thêm bài viết khác: https://tongcucthuevietnam.com/tong-hop

Views:
15
Article Tags:
Article Categories:
Tổng Hợp

Comments

  • Please make more vedios i like your spirit

    Aditya Jha June 25, 2020 6:43 pm Reply
  • I am fall in love with you. Such a nice way of helpful tutorialz.😍

    venu gopal June 25, 2020 6:43 pm Reply
  • Great explanation 🙂 Thank you

    navid nikpour June 25, 2020 6:43 pm Reply
  • Thanks for these such educative tutorials

    somoka elijah June 25, 2020 6:43 pm Reply
  • Thanks for making such complicated function easy

    kelue menanya June 25, 2020 6:43 pm Reply
  • Hi Leila, very interesting with the MOD function. I tried to transform it into my German version but it seems that we can't use this function because the German versions don't have it, or do you anything more? Best wishes! Dirk

    Dirk Outdoor June 25, 2020 6:43 pm Reply
  • Wait, you can pull a number out of a cell with text and use it in a formula??? The more I know, the more I realize I don't know.

    Carlos Gaytan June 25, 2020 6:43 pm Reply
  • How do I copy data from 1 destination(Your Mind) to mine

    Muhammad Mansoor Ali June 25, 2020 6:43 pm Reply
  • I would fall in love with Excel if you were my teacher Leila 🙂

    Eric HENNEQUIN June 25, 2020 6:43 pm Reply
  • Super!! A couple of days ago I looked for this type of function, but never found it! Thank you Leila! Very professional, as usual!

    Danila June 25, 2020 6:43 pm Reply
  • Thanks for the video, Leila! Very helpful.

    Hsu Sophia June 25, 2020 6:43 pm Reply
  • 12:45 An alternative for getting the first letter of the month is to use =LEFT(TEXT(A39,"mmm"),1). This converts the data number values into text and then takes the first letter.

    Cynthia Le (AU) June 25, 2020 6:43 pm Reply
  • 12:32 Formatação Condicional – Meses no Gráfico

    PLAN XLSM June 25, 2020 6:43 pm Reply
  • Wonderful use for mod function

    Mubassir Rangwala June 25, 2020 6:43 pm Reply
  • Holy goodness! I'm not worthy

    Cary Ballard June 25, 2020 6:43 pm Reply
  • It has occurred to me after watching this video that in the parentheses for month were a says A29 there to be A29 -1 right there because the beginning quarter would be on 1/1, 4/1, 7/1, 10/1 and again for 1/1. I don't know if anybody else noticed this yet or not. Its this correct???

    Mark Reddell June 25, 2020 6:43 pm Reply
  • Totally new to me, thank you Leila…

    Meziane Remila June 25, 2020 6:43 pm Reply
  • It doesn't work if your number is not integer. I have function such =Mod(21,9;0,1) and it gives 0,1; Although if I multiply them by 100 so =Mod(2190;10) it gives zero. Why that happens? Is that only my excel or what?

    Ewa June 25, 2020 6:43 pm Reply
  • Had me confused until I realised your dates were m/d/yyyy not d/m/yyyy

    OZ Camper Travels June 25, 2020 6:43 pm Reply
  • @16:00 NA() will make my line disappear! So I decided to Change Chart Type to "Scatter plot"

    @18:15 CountA($B$3:B3)=1 is shocking to me! I used Row(a1)=1…just like @14:01

    I've learned so much, thank you, Leila!

    123rockstar2010 June 25, 2020 6:43 pm Reply
  • Wonderful tips about MoD.

    Asadullah Rozbeh June 25, 2020 6:43 pm Reply
  • Hie Leila thanks for the marvelous excel tips that you post to help us. May you please do a video on how to make a coxcomb chart?

    Amos Lucas June 25, 2020 6:43 pm Reply
  • Groups of 1 would've been even better! 🤔

    DarwishEG June 25, 2020 6:43 pm Reply
  • 🔥🔥🔥

    DarwishEG June 25, 2020 6:43 pm Reply
  • Hi
    You are great i liked how you explain…

    mason simoes June 25, 2020 6:43 pm Reply
  • Excellent explanation appreciated

    Almeda Groom June 25, 2020 6:43 pm Reply
  • Thank! Interesting things of mod function !

    Вадим Онищенко June 25, 2020 6:43 pm Reply
  • Leila, I have been a fan of Excelisfun, now I am becoming also a fan of you. I have seen many of your videos and they are great. Excellent presentations. Congrats.

    Alfredo Silva June 25, 2020 6:43 pm Reply
  • Sorry Sorry , it is not

    Mohammed Kassim Salim June 25, 2020 6:43 pm Reply
  • Dear Leila
    =IF(MOD(ROW(A4),$E$36)=0,B39,"") when i put this formula, it works for the starting cell also

    Mohammed Kassim Salim June 25, 2020 6:43 pm Reply
  • Wonderful video with clear explanations

    mahamohan1 June 25, 2020 6:43 pm Reply
  • Ma'am you are outstanding 👍

    javed shaikh June 25, 2020 6:43 pm Reply
  • Thanks Leila, good stuff. Thank you.

    Steve T June 25, 2020 6:43 pm Reply
  • Hi Leila
    Thanks for sharing this very interesting video with us.
    Very smart excel features that can be implemented immediately in our daily professional life.
    Very creative & sophisticated techniques.

    Hattem Ghanoom June 25, 2020 6:43 pm Reply
  • Hi Leila, I am becoming addicted to your lectures can you imagine I spent all my weekend just watching your videos?for you information I am a CFO and I found your tips very useful in preparing my presentations to the BOD. I am now giving the charts to my secretary in order for her to prepare my power point presentations,one question, how can I get the excel workbook that you have used for this video?many thanks,Ghassan

    Ghassan Nashi June 25, 2020 6:43 pm Reply
  • In this video I can't see any thing except you 😍

    Kamrul Zoha June 25, 2020 6:43 pm Reply
  • Great examples!

    AlergicToSnow June 25, 2020 6:43 pm Reply
  • Thanks Mam !, it's very useful to me !

    Shirish Shelke June 25, 2020 6:43 pm Reply
  • Great video again. ☺️ Excel is so addictive. 😅

    Hoppi Hopp June 25, 2020 6:43 pm Reply
  • Un gros merci Leila ton explication est excellente 🙂 je comprend beaucoup mieux cette fonction

    Mario Limoges June 25, 2020 6:43 pm Reply
  • Brilliant Leila! For the first minute or so of this video I was thinking what is the point of the MOD function, but I can now definitely see where I could make good use of this! Thanks for sharing 🙂

    Steve Benford June 25, 2020 6:43 pm Reply
  • My email for linked in is baniasadi67@gmail.com

    SoftwareTrain June 25, 2020 6:43 pm Reply
  • Dear Leila,
    I have a strange problem with this function.
    Please test this number and check the result,
    =MOD(28.8,9.6)
    It should be zero but its not.
    Could you please tell me cause of this problem?
    I think this is a bug in EXCEL.

    SoftwareTrain June 25, 2020 6:43 pm Reply
  • hiii leila what is the simple way of vlookup formula in excel

    Tarun Kumar June 25, 2020 6:43 pm Reply

Leave a Reply

Your email address will not be published. Required fields are marked *