Forum Discussion
sa1466_
Oct 26, 2022Copper Contributor
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.5 | 5.7 | 15.2 | 5 | 10.2 |
| 9.5 | 8.4 | |||
| 9.5 | 0.9 |
The first row I want the formulas to work and the next 2 rows I do not
Thanks
1 Reply
- OliverScheurichGold Contributor