Excel Help - IF Function maybe?

kerrie - Feb 22, 2018 at 09:01 AM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- 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

Thanks
Kerrie
See more 

Your reply

1 reply

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Feb 22, 2018 at 05:00 PM
0
Thank you
The syntax for IF is as follows:
=IF(logic_test,true,false)

SO, we get:
=IF(a1>b1,c1-(a1+b1))

It is that simple.

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