If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formula
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 |
#2
|
|||
|
|||
Conditional Formula
Yeroc 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 |
Thread Tools | |
Display Modes | |
|
|