I'm hoping someone can help. I am trying to work out how to calculate the following by the information populated in my cells. For example, Cell A (Actual) = 20. Cell B (Stock) = 3, Cell C (Forecast)= 23, I want Cell D to give me the sum if A is greater than B and then the difference from Cell C?
In addition to the above i also have another one:
Cell A =3
Cell B = 34
Cell C = yes or no
The result i am looking for is if Cell C say "no" it will automatically populate a 0 AND if the same cell says "yes", i want it to give me the numeric difference between cell a & B
Need this urgently!!!! if anyone can help pleaasssse