When I paste =and(V26<0,Settings!C14=TRUE) in a cell, it evaluates correctly, to TRUE.
When I enter the same formula in Custom Formula I get an error as shown.
How can I correct this please?

It seems that Indirect is a way to go
=and(V26<0,INDIRECT("Settings!C14")=TRUE)
works
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With