Support Board
Date/Time: Fri, 14 Mar 2025 13:41:59 +0000
Post From: SPREADSHEET FORMULA HELP ZONAL ENTRY!
| [2022-06-20 12:55:32] |
| Sawtooth - Posts: 4182 |
|
Try this: Zone above POC: =AND(E3>ID3.SG2@3,E3<ID3.SG2@3+$J$21*n) Zone below POC: =AND(E3<ID3.SG2@3,E3>ID3.SG2@3-$J$21*n) Zone straddling POC: =AND(E3>ID3.SG2@3-$J$21*n,E3<ID3.SG2@3+$J$21*n) |