AND logic

Hello @clonemykey

The equation would be similar to:

IF(AND(2<=fieldname27, fieldname27<=4), 18.95, 1)*fieldname27;

Best regards.

Hmmm that’s not working either. I’ll have to play around with it some more.

Hello @clonemykey

Please, send me the link to the page where the form is inserted to check the equation in action.

Best regards.

https://clonemykey.com/dev/dev_format/ [password redacted]

• This reply was modified 4 years, 1 month ago by Steven Stern (sterndata).

@clonemykey Please don’t offer to send or post logon credentials on these forums: https://www.ads-software.com/support/guidelines#the-bad-stuff

You may trust this developer/author, but it normalizes a dangerous practice. It’s a fine line, but one that we need to enforce. Thanks for your cooperation.

Hello @sterndata

This is not a logon credential, is the public page configured as private because the form is in development, and the @clonemykey does not want to make it public for everyone yet.

Best regards.

OK, @clonemykey, you can post the password for that page.

P/w is cmk131

Hello @clonemykey

The equation recommended was simply:

IF(AND(2<=fieldname27, fieldname27<=4), 18.95, 1)*fieldname27;

If you want use the previous code with a function structure, you should use a “return” instruction as follows:

(function(){ return IF(AND(2<=fieldname27, fieldname27<=4), 18.95, 1)*fieldname27;})()

Best regards.

@codepeople

Thanks, that works! I was returning after the statement was evaluated but this was an easy fix.