• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

Conditional Formula

Y

Yeroc

Flightless Bird
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.
 
J

JoAnn Paules

Flightless Bird
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@discussions.microsoft.com> wrote in message
news:59D7C89C-4217-4F08-A5D6-6CECE6CB86DD@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.
 
Top