Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 20 Apr 2024 03:49:07 +0000
Post From: Need help Error #DIV/0- using Study
| [2017-12-02 16:46:12] |
| Sawtooth - Posts: 3976 |
|
Try this: =IF(OR(AV=0,BV=0), OR(AND(H-L>11,O-C>8,V>V[1]),AND(H-L>11,C-O>8,V>V[1])), OR(AND(H-L>11,O-C>8,V>V[1],BV/AV>BV[1]/AV[1]),AND(H-L>11,C-O>8,V>V[1],AV/BV>AV[1]/BV[1]))) |