I have two columns. One has cost (column A) and the other has profit (column B). I'd like to calculate the percentage profit as a function of how much something cost. So, if it cost $100 and the profit was $20 I would like to calculate 20%. For all percentages, I'd like to average them. I understand this is a "weighted average" and was able to get this working with this formula:
However, I don't want to include entries where the profit column has a negative value. I tried something like this:Please Login or Register to view this content.
This doesn't seem to work quite right as it's not ignoring the cost entry when the profit entry is negative. Any advice?Please Login or Register to view this content.
Bookmarks