Excel Help - IF Function maybe?

kerrie - Feb 22, 2018 at 09:01 AM
 Blocked Profile - Feb 22, 2018 at 05:00 PM
Hi All,

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


1 response

Blocked Profile
Feb 22, 2018 at 05:00 PM
The syntax for IF is as follows:

SO, we get:

It is that simple.

If a1 is greater than B1, subtract A1+b1 from c1.