what´s wrong with this expression?

  • Resolved raulelenes

    (@raulelenes)


    13 years, 4 months ago

    what’s wrong with this formula expression?

    IF(AND(dom=1,IF(AND(weight>500,weight<1001),200.00,0))

    I like that with dom=1 condition and weight higher than 500 and lower than 100, results in 200 value, if not in 0, but I believe this is wrong expressed and yields a #NAME? and #REF! errors

    http://ww.wp.xz.cn/extend/plugins/jazzy-forms/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter raulelenes

    (@raulelenes)

    13 years, 4 months ago

    Another tested variation was:

    IF(AND(dom=1,IF(AND(weight>500,weight<1001),200.00,0),0)

    and didn´t work at all.

    Thread Starter raulelenes

    (@raulelenes)

    13 years, 4 months ago

    I just realized with some excel logic expressions research the right expression:

    IF(AND(dom=1,AND(weight>500,weight<1001)),200.00,0)

    and worked ok!

    scattered810

    (@scattered810)

    13 years, 3 months ago

    Raulelenes, that bit of code for using three variable with the and statement worked perfectly for me. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘what´s wrong with this expression?’ is closed to new replies.