Conditional Formula

Y

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
 
Z

Zaidy036

Yeroc said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top