如何在Excel中计算比例公式中的项目数量?

I am trying to find a ratio-like formula that takes into account the difference between the number of items in stock and those that are on sale, as well as the actual number of items in stock and on sale. I am trying to find a ratio-like formula that t