Skip to main content
W
wkhalid1-Visitor
1-Visitor
September 8, 2014
Solved

if function

  • September 8, 2014
  • 1 reply
  • 4091 views

Hi

How can I use if function when I have two statement shall be valid at the same time:

For example:

y=0 if x=5 and z=10

y=1 otherwise

How can I replace "and"?

Thanks

Best answer by MikeArmstrong

Like so.

Clipboard01.jpg

1 reply

M
MikeArmstrong1-VisitorAnswer
1-Visitor
September 8, 2014

Like so.

Clipboard01.jpg

    M
    MikeArmstrong1-Visitor
    1-Visitor
    September 8, 2014

    Sorry, the and function can be found on the Boolean toolbar or by Ctrl+&.

    Terms & ConditionsAccessibility statement