1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Conditional Formula

Discussion in 'Microsoft Office' started by Yeroc, May 31, 2010.

  1. Yeroc

    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.
     
  2. JoAnn Paules

    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.
     

Share This Page