plus or minus another cell

[aaronwexler]

I have the following formula:

=IF(AND(D4<D3,D4<D5,E3>B3,E3>C4,C5>C4,),D3-10,0)

and I want to add a part to the formula that adds the following condition:

D4 = BK4 plus or minus 5

For example if BK = 100 I want the additional condition to be true if D4 is in the range 95-105 but I am not sure how to write this.

[Bryan Hessey]

I have the following formula:

=IF(AND(D4<D3,D4<D5,E3>B3,E3>C4,C5>C4,),D3-10,0)

and I want to add a part to the formula that adds the following condition:

D4 = BK4 plus or minus 5

For example if BK = 100 I want the additional condition to be true if D4 is in the range 95-105 but I am not sure how to write this.

Hi

something like

=IF(AND(D4<D3,D4<D5,E3>B3,E3>C4,C5>C4,AND(D4>=BK4-5,D4<=BK4+5)),D3-10,0)

hth
---

[aaronwexler]

That is pretty much how I was trying to write it I just thought there might be a better way to do it.

Thank You

[Bryan Hessey]

That is pretty much how I was trying to write it I just thought there might be a better way to do it.

Thank You

Hi,

the most simple, shortest way always works for me, and thanks for your response.

---