Nov 29 2021 06:56 AM
Dear Community,
I am looking for a formula that completes cells with a salary budget calendar from the month of employment onwards: Employment start column cell (now March) is a drop-down list. When this month changes, the cell with the respective months forward should change (now March, April, May, June), and all previous months to be 0 (like in January, February).
Thank you for your advice in advance.
Q1 | Q2 | ||||||
Salary | Employment start | January | February | March | April | May | June |
10 000,00 Kč | March | - Kč | - Kč | 10 000,00 Kč | 10 000,00 Kč | 10 000,00 Kč | 10 000,00 Kč |
Dec 10 2021 02:05 AM
You may achieve your requirement using below formula:
=IF((C2>=$B$4),$A$4,0)
You may also refer to the attached file for more clarity.
Please let me know if it works for you.
Thanks
Tauqeer
Dec 10 2021 03:46 AM
Dear @tauqeeracma,
Thank you very much for your kind assistance. I already solved this riddle by IF formula, but your help is appreciated. :thumbs_up:
All the best!
Jan
Dec 10 2021 04:31 AM
For anyone with Excel 365 this reduces to a formula for the displayed dates and a single spilt range formula for employees
= EOMONTH(displayStart, SEQUENCE(1,12,0))
= IF(displayDate>=employmentStart, Salary, "")
For those without 365 (or Excel 2021), bad luck! My sympathies.
Dec 13 2021 04:14 AM
Dec 13 2021 08:44 AM
SolutionIf you do have Excel 2021, the attached file should work. Formulae are to be found in the blue shaded cells and the two columns to the left are an Excel Table
Dec 16 2021 12:08 AM
Dec 13 2021 08:44 AM
SolutionIf you do have Excel 2021, the attached file should work. Formulae are to be found in the blue shaded cells and the two columns to the left are an Excel Table