What formula to use if you want to make reference to 2 cells;
example: If year A1 equal to B10 the maximum value it can have is 2

I am sure there is a way. What kind of information is in A1? Is it a date
or just the year? Is B10 always going to be the cell you compare too? And
what do you want to do if the A1<B10?


--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Link" wrote:

What formula to use if you want to make reference to 2 cells;
example: If year A1 equal to B10 the maximum value it can have is 2

the month and year is A1 . I was a formula to say if A1 equal to B10 1( in
this case if A1 and B10 are the same month it should be 1 or less.

"PJFry" wrote:

I am sure there is a way. What kind of information is in A1? Is it a date
or just the year? Is B10 always going to be the cell you compare too? And
what do you want to do if the A1<B10?


--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Link" wrote:

What formula to use if you want to make reference to 2 cells;
example: If year A1 equal to B10 the maximum value it can have is 2

If both A1 and B10 are in date formats try this formula. Change the values
you want accordingly//In the below example if both months are same it will
return 1 and if not 2. Adjust as required.

=IF(Month(A1)=Month(B10),1,2)

--
If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

the month and year is A1 . I was a formula to say if A1 equal to B10 1( in
this case if A1 and B10 are the same month it should be 1 or less.

"PJFry" wrote:

I am sure there is a way. What kind of information is in A1? Is it a date
or just the year? Is B10 always going to be the cell you compare too? And
what do you want to do if the A1<B10?


--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Link" wrote:

What formula to use if you want to make reference to 2 cells;
example: If year A1 equal to B10 the maximum value it can have is 2

Thanks Jacob,

I want it to be either 1 or less than 1 (the maximum should be 1 )

"Jacob Skaria" wrote:

If both A1 and B10 are in date formats try this formula. Change the values
you want accordingly//In the below example if both months are same it will
return 1 and if not 2. Adjust as required.

=IF(Month(A1)=Month(B10),1,2)

--
If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

the month and year is A1 . I was a formula to say if A1 equal to B10 1( in
this case if A1 and B10 are the same month it should be 1 or less.

"PJFry" wrote:

I am sure there is a way. What kind of information is in A1? Is it a date
or just the year? Is B10 always going to be the cell you compare too? And
what do you want to do if the A1<B10?


--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Link" wrote:

What formula to use if you want to make reference to 2 cells;
example: If year A1 equal to B10 the maximum value it can have is 2

Do you mean

=IF(Month(A1)=Month(B10),1,0)

If not post back with what value you are expecting..if the month is not same..

If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

Thanks Jacob,

I want it to be either 1 or less than 1 (the maximum should be 1 )

"Jacob Skaria" wrote:

If both A1 and B10 are in date formats try this formula. Change the values
you want accordingly//In the below example if both months are same it will
return 1 and if not 2. Adjust as required.

=IF(Month(A1)=Month(B10),1,2)

--
If this post helps click Yes
---------------
Jacob Skaria


"Link" wrote:

the month and year is A1 . I was a formula to say if A1 equal to B10 1( in
this case if A1 and B10 are the same month it should be 1 or less.

"PJFry" wrote:

I am sure there is a way. What kind of information is in A1? Is it a date
or just the year? Is B10 always going to be the cell you compare too? And
what do you want to do if the A1<B10?


--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Link" wrote:

What formula to use if you want to make reference to 2 cells;
example: If year A1 equal to B10 the maximum value it can have is 2