View Single Post
  #2  
Old June 1st, 2010, 09:00 PM posted to microsoft.public.office.misc
JoAnn Paules
external usenet poster
 
Posts: 10,630
Default 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.