Forum Discussion

Copper Contributor

Dec 06, 2021

IF statement with 2 variables

Can someone assist. If 2<3 and 1>2, true = 2 false = 0 How do I write this IF statement ?

Formulas and Functions

Brass Contributor

Dec 06, 2021

Something like:
IF(AND(2 < 3; 1 > 2); 2; 0)

Copper Contributor

Dec 06, 2021

I have tried and its not working
=IF(AND(E36 < E41; E38 > E36); E36; 0)

cbarroso
Brass Contributor
Dec 06, 2021
I guess the formula is working but the resul is not what you expect 🙂
Can u provide a sample of data with the expected result?
- kmcdermott1974
  Copper Contributor
  Dec 06, 2021
  cbarroso
  E36=$400
  E38=$2240
  E41= $2410
  
  E43=formula
  
  so IF E36<E41 and E38>E36 YES then E43 = E36 NO then E43=0
  400<2410 YES and 2240>400 YES then E43=$400
  
  Further to this IF E36<E41 and E38<E36 YES then E43=E36 NO then E43=0
  - kmcdermott1974
    Copper Contributor
    Dec 06, 2021
    tried yours exactly still comes up with problem. even added = before IF and still problem ?!?
- cbarroso
  Brass Contributor
  Dec 06, 2021
  A B C RESULT (IF(AND(B2>A2;B2<C2);B2;0)) 1 2 3 2

Resources