L
Link
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
example: If year A1 equal to B10 the maximum value it can have is 2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PJFry
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?
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?
L
Link
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.
this case if A1 and B10 are the same month it should be 1 or less.
J
Jacob Skaria
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)
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)
L
Link
Thanks Jacob,
I want it to be either 1 or less than 1 (the maximum should be 1 )
I want it to be either 1 or less than 1 (the maximum should be 1 )
J
Jacob Skaria
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
=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
L
Link
I want the cell to be the maximum 1 ( meaning it could be less than 1)
J
Jacob Skaria
For example in the below if month(A1) and month(B1) has a difference of 5
what is expected.
=IF(Month(A1)=Month(B10),1,0)
what is expected.
=IF(Month(A1)=Month(B10),1,0)
J
Jacob Skaria
I say your other post...Is this what you are looking for ?
=IF(Month(B2)=Month(D10),1,D11+D12-D13)
If this post helps click Yes
=IF(Month(B2)=Month(D10),1,D11+D12-D13)
If this post helps click Yes
L
Link
It is still giving me error message; any other suggestion?
J
Jacob Skaria
Do you mean...
=IF(Month(B2)=Month(D10),1,MIN(1,D11+D12-D13))
=IF(Month(B2)=Month(D10),1,MIN(1,D11+D12-D13))
L
Link
maybe I am not explaining correctly. The formula is not working. I am
trying to copy what I have and paste it in the message box, but it is not
pasting correctly.
trying to copy what I have and paste it in the message box, but it is not
pasting correctly.
J
Jacob Skaria
I will explain what the formula does and from there you should be able to
take up...
The IF condition in the formula If( a condition, value to return if
condition is true, value to return if condition is false)
Month is a function to return month from a date cell
So here we are comparing the month of B2 with that of D10. If both are same
we are returning the value as 1 which I think is what you require.
If the month is not same then we are taking the minimum of 1 and
d11+d12+d13. I am not sure what this calculation is . If you look at your
previous replies and even your original query you have not mentioned the
condition at all. I got this D11+D12-D13 from your other post...
=IF(Month(B2)=Month(D10),1,MIN(1,D11+D12-D13))
If this post helps click Yes
take up...
The IF condition in the formula If( a condition, value to return if
condition is true, value to return if condition is false)
Month is a function to return month from a date cell
So here we are comparing the month of B2 with that of D10. If both are same
we are returning the value as 1 which I think is what you require.
If the month is not same then we are taking the minimum of 1 and
d11+d12+d13. I am not sure what this calculation is . If you look at your
previous replies and even your original query you have not mentioned the
condition at all. I got this D11+D12-D13 from your other post...
=IF(Month(B2)=Month(D10),1,MIN(1,D11+D12-D13))
If this post helps click Yes
L
Link
Jacob thank for your help!
I put bracket beside your question what the calculation I want.
I put bracket beside your question what the calculation I want.
L
Link
Jacob, I typed below in bracket next to the questions you asked. I am trying
hard to explain.
Month is a function to return month from a date cell
hard to explain.
Month is a function to return month from a date cell