0

I have a small problem to solve and I hope you guys can solve it easily.
So currently I have a calculated column which calculates the value but only when the status is available, so it looks like this
IF(Status="available",=SUM([column1]-[column2])
Now what I want is to check as on or condition if it the status is consumed too. So it can work for both the status properly.
Please respond if you know how to do this ! Thanks

3

If I understand you correctly then these two formulas should do the trick:

=IF(Status="available",column1+column2,IF(Status="consumed",column1+column2))

=IF(OR(Status="available",Status="consumed"),column1+column2)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.