Hi All,
I have tried my hardest to deal with a simple enough formula, but cannot get the formatting correct for it to generate what I need.
I have a quantity parameter which I need to mutiply the amount by, depending on whether the LHS or RHS is on or they are both off. So I have 3 scenarios:
Can anyone help create the correct formula for this?
Cheers
I have tried my hardest to deal with a simple enough formula, but cannot get the formatting correct for it to generate what I need.
I have a quantity parameter which I need to mutiply the amount by, depending on whether the LHS or RHS is on or they are both off. So I have 3 scenarios:
- Both on, which would require the quantity parameter to be x by 2.
- 1 on and 1 off, which require the quantity parameter to be x by 1. I.e no change from the quantity number
- Both off, which requires the quantity parameter to return a 0.
Can anyone help create the correct formula for this?
Cheers
Comment