what′s wrong with this expression?

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

    (@raulelenes)

    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)

    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!

    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.