Compare two cells, greater or less than by 2 or more

[dandanfielding]

I'm looking to write a formula comparing two cells. If the second cell is greater or less than the first cell by 2 or more, I need to increment or decrement the value in the first cell by 1 for every 2 points of difference. I'm kind of stumped. I've tried nested IF statements, so far with no luck.

 

[yanaa]

can i see the file

 

[awoohaw]

try this:

mr excel questions 21.xlsm
	A	B	C
1	Value1	Value2	NewValue
2	1	1	1
3	1	2	1
4	1	3	2
5	2	1	2
6	2	2	2
7	2	3	2
8	2	4	3
9	2	5	3
10	2	6	4
dandanfielding

Cell Formulas
Range	Formula
C2:C10	C2	=IF(A2+2<=B2,A2+ROUNDDOWN((B2-A2)/2,0),A2)

 

[dandanfielding]

try this:

mr excel questions 21.xlsm
	A	B	C
1	Value1	Value2	NewValue
2	1	1	1
3	1	2	1
4	1	3	2
5	2	1	2
6	2	2	2
7	2	3	2
8	2	4	3
9	2	5	3
10	2	6	4
dandanfielding

Cell Formulas
Range	Formula
C2:C10	C2	=IF(A2+2<=B2,A2+ROUNDDOWN((B2-A2)/2,0),A2)

Thank you, this worked!

 

[awoohaw]

My pleasure. And welcome to the forum.

If you think a post here has provided you with a solution, please mark it as the answer.

Best wishes.

 

[dandanfielding]

My pleasure. And welcome to the forum.

If you think a post here has provided you with a solution, please mark it as the answer.

Best wishes.

Thanks for the warm welcome! I didn't notice an option to mark a reply as the solution, but after your reply I found it and have done so.