I had a formula in Power apps for 2021 but now I have 2022 data and I need to update my formula to capture. How Can I write a formula to with an "OR" inside an "IF". Here is my formula:
If(Value(DataCardValue_Shrink.Text) > 0, (Round(If(Dropdown_Product.Selected.Result="YB21", ((DataCardValue17) / 60), (DataCardValue17) / 56) - Value(DataCardValue_Shrink.Text)*1.5*(If(Dropdown_Product.Selected.Result = "YB21", ((DataCardValue17) / 60) , If(Dropdown_Product.Selected.Result = "YB21",((DataCardValue17)/60)), (DataCardValue17) / 56)),2)),Round(If(Dropdown_Product.Selected.Result ="YB21", ((DataCardValue17) / 60), (DataCardValue17) / 56),2))
I either want the OR to be "YB21" or "YB22" or can is there a contain formula to say the result CONTAINS YB so I don' t have to change every year? THANKS!!!
