Hi,
I am trying to limit the number entered into two cells. One is the number of times a program can be offered in a year and the other is the number of months it will run during the year. For example, I run a course that goes for 3 months of the year and I run it 4 times a year. Cell A1 is the number of times I run it a year (4) and A2 is the number of times a year I offer enrolments (3). Each of these cells must be a number between 1 and 12 but A1*A2 must not exceed 12.
How do I set up a data validation for this?
Thank you so much! I am going round the bend with this haha.
I am trying to limit the number entered into two cells. One is the number of times a program can be offered in a year and the other is the number of months it will run during the year. For example, I run a course that goes for 3 months of the year and I run it 4 times a year. Cell A1 is the number of times I run it a year (4) and A2 is the number of times a year I offer enrolments (3). Each of these cells must be a number between 1 and 12 but A1*A2 must not exceed 12.
How do I set up a data validation for this?
Thank you so much! I am going round the bend with this haha.