Conditional Formula

[Yeroc]

I am fairly new to using formulas but want a formula to do the following:

A B C
1 10 5 6
2 9 9
3

Figures entered into column A & B & Formula in column C.
Formula for C1 is A1 + B1 - A2
Help for the below
The formula for C2 is A2 + B2 - C3 but if C2 = A2 I want the value to be 0

Please help

 

[Zaidy036]

Yeroc <Yeroc@discussions.microsoft.com> wrote:
> I am fairly new to using formulas but want a formula to do the
> following:
>
> A B C
> 1 10 5 6
> 2 9 9
> 3
>
> Figures entered into column A & B & Formula in column C.
> Formula for C1 is A1 + B1 - A2
> Help for the below
> The formula for C2 is A2 + B2 - C3 but if C2 = A2 I want the value to
> be 0

Please help

Add column "D" then use if(c2=d2,0,c2) in D2

Hide col C if you do not want to see it