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.
|