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://vmmotorsdaihan.com

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

### Xem thêm Bài Viết:

- Bật mí cách sửa lỗi Product activation failed hiệu quả không phải ai cũng biết
- Hướng dẫn insert checkbox trong word đơn giản và nhanh chóng
- Kinh nghiệm sửa lỗi a required cd/dvd drive device driver is missing
- Polling rate là gì? Chế độ vận hành của chuột và những điều bạn nên biết!
- Tự học Powerpoint Cấp tốc trong 20 phút

## Aditya Jha

June 17, 2020Please make more vedios i like your spirit

## venu gopal

June 17, 2020I am fall in love with you. Such a nice way of helpful tutorialz.😍

## navid nikpour

June 17, 2020Great explanation 🙂 Thank you

## somoka elijah

June 17, 2020Thanks for these such educative tutorials

## kelue menanya

June 17, 2020Thanks for making such complicated function easy

## Dirk Outdoor

June 17, 2020Hi 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

## Carlos Gaytan

June 17, 2020Wait, 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.

## Muhammad Mansoor Ali

June 17, 2020How do I copy data from 1 destination(Your Mind) to mine

## Eric HENNEQUIN

June 17, 2020I would fall in love with Excel if you were my teacher Leila 🙂

## Danila

June 17, 2020Super!! A couple of days ago I looked for this type of function, but never found it! Thank you Leila! Very professional, as usual!

## Hsu Sophia

June 17, 2020Thanks for the video, Leila! Very helpful.

## Cynthia Le (AU)

June 17, 202012: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.

## PLAN XLSM

June 17, 202012:32 Formatação Condicional – Meses no Gráfico

## Mubassir Rangwala

June 17, 2020Wonderful use for mod function

## Cary Ballard

June 17, 2020Holy goodness! I'm not worthy

## Mark Reddell

June 17, 2020It 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???

## Meziane Remila

June 17, 2020Totally new to me, thank you Leila…

## Ewa

June 17, 2020It 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?

## OZ Camper Travels

June 17, 2020Had me confused until I realised your dates were m/d/yyyy not d/m/yyyy

## 123rockstar2010

June 17, 2020@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!

## Asadullah Rozbeh

June 17, 2020Wonderful tips about MoD.