Three methods of Excel to solve the problem of amount allocation in daily work

The original title: "I secretly used these three tips at the end of the month, and I never worked overtime for Excel again." "

Among the many professions that use Excel, accountants have to deal with forms every day.

Especially at the end of the month and the beginning of the month, there are many watches and big heads.

It's a daily meal to work overtime every day.

One of the tasks is to allocate the amount.

For example, in the following small example, you need to allocate the amount in the first column to the following month according to the month in the second column:

For example, the second line 3500 needs to be allocated in the following three months according to three months. In January 2022, 3500 prizes will be allocated in February 2022. 3500 prizes will be allocated in February 2022. In March 2022, 3500 will be allocated. If the allocation exceeds three months, the amount will not be allocated.

According to this idea to allocate the amount, how to operate it?

Let's take a look at some tips to solve this problem.

IF function + MONTH function

To solve this kind of problem, we mainly use the conditional judgment function as the main idea.

If the condition is true, one value is returned, otherwise another value is returned.

Expressed in a formula is:

IF (condition, the value returned when the condition is true, and the value returned when the condition is not true)

The complete formula is as follows:

= IF (MONTH (Clip1)