Create checklist monthly and quarterly in excel

0
votes

I have created checklist as per the attached image in excel.Checklist image

Explanation- I have to create checklist to check the progress of reports in excel. I have divided the period as monthly and quarterly.

Note : Quarterly includes March, June, September, December and Monthly includes remaining months.

B4 cell is checked quarterly, where as B5 and B6 cells are checked Monthly basis. The checkbox's on column C is liked to column D. Cell A1 is drop-down menu which has months from JAN - DEC.

I want to select March in Cell A1 (that is quarterly period), after selecting the quarter month- In cell E5 & E6 I want to display N/A in Monthly and in F5 & F6 i need to show 1 or 0 as per the checkbox in column C.

Like wise if i select APRIL( Which is not quarter month) I need to display "N/A" in F5 & F6 and 1 or 0 in E4 based on checkbox checked value true or false.

Can some one suggest logic.

1
excelexcel-formula
'Can some one suggest logic.' is not a specific programming question. idownvotedbecau.se/noattempt – user4039065

1 Answers

0
votes

Checklist Logic Checklist:

  ☑ Design Template.

  ☐ Learn how to use Excel's IF Worksheet Function. (see below)

  ☐ Use IF Function to change value of cells E5:F6 depending on value of drop-down.

More information: