Add/Subtract IF cell is "FALSE"

[dg3]

I have a column that has values TRUE and FALSE, they are the result of a "=A=B" formula. In column D I want to perform B-A IF value C is FALSE. Is there a way to do this? If value is true, do nothing or return 0. Heres what I am hoping for

A....B...C...D

1...1..TRUE..........
2...2....TRUE..........
3....3....TRUE..........
4....5.....FALSE..... 5-4=1
6.....7.....FALSE.....7-6=1
8....8.....TRUE

[JieJenn]

=if(c=false, b-a, "")

[newdoverman]

Just a minor adjustment to the formula given by JieJenn:

Please Login or Register  to view this content.

[martindwilson]

well that can be
=IF(C1,"",B1-A1)