Forum Discussion

sa1466_'s avatar
sa1466_
Copper Contributor
Oct 26, 2022

can this be done?

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