Share via

"IFS" function

Anonymous
2024-11-13T12:20:27+00:00

Чи можливо у функції “IFS”   рядок   «Логічна перевірка 2»  прописати  часовий діапазон з інтервалом  в один рік , два роки, три роки  і т.д.

Is it possible to write a time range with an interval of one year, two years, three years, etc. in the "IFS" function in the "Logical check 2" line?

Microsoft 365 and Office | Excel | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-11-13T14:52:00+00:00

    Is it possible to write a time range with an interval of one year, two years, three years, etc. in the "IFS" function in the "Logical check 2" line?

    No.

    What should be the point? IFS is the same as a stacked IF:

    if K13 is greater [Date 1] then "this result" else if K13 is greater [Date 2] then "other result" else and so on.

    BTW, in your screenshot "31.122023" is not a date, use DATE(2023,12,31) instead.

    Andreas.

    Was this answer helpful?

    0 comments