Hi im trying to create a multiple if statement where if a number from a gallery is larger than 24 or smaller than the gallery number then update a variable,
previously i had these the two if statments and two variables and it worked however my app now needs to combine them (this is the working code)
If(Value(Can_SMU.Text) > Value(Sum(Gallery3.AllItems, Value(ASS_SMU.Text))) + 24, UpdateContext({CalButton:true}),UpdateContext({CalButton:false}) &
If(Value(Can_SMU.Text) < Value(Sum(Gallery3.AllItems, Value(ASS_SMU.Text))), UpdateContext({CalButton2:true}),UpdateContext({CalButton2:false})))
and this is what i thought should work?
If(Value(Can_SMU.Text) > Value(Sum(Gallery3.AllItems, Value(ASS_SMU.Text))) + 24 || If(Value(Can_SMU.Text) < Value(Sum(Gallery3.AllItems, Value(ASS_SMU.Text))), UpdateContext({CalButton:true}),UpdateContext({CalButton:false})))
but it does not?
im a mong
its
If(Value(Can_SMU.Text) > Value(Sum(Gallery3.AllItems, Value(ASS_SMU.Text))) + 24, UpdateContext({CalButton:true}),UpdateContext({CalButton:false}) &
If(Value(Can_SMU.Text) < Value(Sum(Gallery3.AllItems, Value(ASS_SMU.Text))), UpdateContext({CalButton:true}),UpdateContext({CalButton:false})))