Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Wed, 27 Nov 2024 10:00:05 +0000

How to Post a Message for Support

Post From: NoCLR version gives alert formula errors

[2014-08-13 03:36:30]
[Go To First Post]
rc7rader - Posts: 144
Okay I fixed it. I checked the Non-CLR spreadsheet functions and my formula was okay, except in the old version I had it written out like this so I can easily read each criteria.

=OR(
AND(C>=ID3.SG15-0.10, C<=ID3.SG15+0.10),
AND(C>=ID3.SG16-0.10, C<=ID3.SG16+0.10),
AND(C>=ID3.SG17-0.10, C<=ID3.SG17+0.10),
AND(C>=ID3.SG18-0.10, C<=ID3.SG18+0.10)
)

In the non-CLR version, it has to be written out in one line.

=OR(AND(C>=ID3.SG15-0.10, C<=ID3.SG15+0.10),AND(C>=ID3.SG16-0.10, C<=ID3.SG16+0.10),AND(C>=ID3.SG17-0.10, C<=ID3.SG17+0.10),AND(C>=ID3.SG18-0.10, C<=ID3.SG18+0.10))