I hope this is an easy one!
This is what I have:
Column A represents the initial year of an event (a value 1 through 10)
Column B represents the number of years it takes for the event to happen again
So if in a given row Column A has 3 and Column B has 5 - the event happens in years 3, 8, 13, 18, etc.
On another sheet I have a column with a list years 1 through 100. In the column next to this I want to put an equation that will tell me if the year in the adjacent cell is one in which the event happens.
Can anyone help me out with this? Is there a function that returns true if a number is a multiple of another? Or one that returns true if a number is an integer?
This is what I have:
Column A represents the initial year of an event (a value 1 through 10)
Column B represents the number of years it takes for the event to happen again
So if in a given row Column A has 3 and Column B has 5 - the event happens in years 3, 8, 13, 18, etc.
On another sheet I have a column with a list years 1 through 100. In the column next to this I want to put an equation that will tell me if the year in the adjacent cell is one in which the event happens.
Can anyone help me out with this? Is there a function that returns true if a number is a multiple of another? Or one that returns true if a number is an integer?