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
Fairly new to using formula's
I am trying to develope a formula that will: In cell B2 = A2 - A3 but if B2=A2 I want the value to be "0". A B 1 33 11 2 22 22 3 0 Please help. |
#2
|
|||
|
|||
Conditional Formula
You have to add another column. Using your example and adding a column C:
Cell C2 would contain the formula =IF(B2=A2,"0",(A2-A3)) -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Yeroc" wrote in message ... Fairly new to using formula's I am trying to develope a formula that will: In cell B2 = A2 - A3 but if B2=A2 I want the value to be "0". A B 1 33 11 2 22 22 3 0 Please help. |
Thread Tools | |
Display Modes | |
|
|