can this be done?

Occasional Visitor

wanting to know if this formula can be written in excel

if B1<(a1-2) or B1 is >1 then c1-d1 can happen if b1 is not in this range then c1-d1 cannot happen.

9.55.715.2510.2
9.58.4   
9.50.9   

 The first row I want the formulas to work and the next 2 rows I do not

 

Thanks

1 Reply

@sa1466_ 

=IF(OR(B1<A1-2,B1>1),C1-D1,"")

You can try this formula.

B1.JPG