Prev: Groove Workspace - How do I share/add users to my workspace?
Next: Training Material from MS Getting to Know
From: Yeroc on 1 Jun 2010 02:42
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

From: Zaidy036 on 1 Jun 2010 04:48
Yeroc <Yeroc(a)discussions.microsoft.com> 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
From: JoAnn Paules on 1 Jun 2010 16:00
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" <Yeroc(a)discussions.microsoft.com> wrote in message
news:59D7C89C-4217-4F08-A5D6-6CECE6CB86DD(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Groove Workspace - How do I share/add users to my workspace?
Next: Training Material from MS Getting to Know