iWorks Numbers: how set an if/then condition?

Discussion in 'Mac Apps and Mac App Store' started by mrzeigler, Sep 7, 2013.

Most Liked Posts
  1. mrzeigler, Sep 7, 2013
    Last edited: Sep 7, 2013

    mrzeigler macrumors regular

    Joined:
    Oct 15, 2005
    Location:
    Pittsburgh
    #1
    Using numbers, I want to set up a formula to do the following:

    * If Column E = "Y," then subtract the value of column I from the value of column L.

    * If Column E is anything but a "Y", return a value of "0".


    I've never had to deal with a conditional in a formula before, and my searches keep revealing tips for conditional formatting.

    Any help would be appreciated. Thanks.


    UPDATE: Nevermind. I figured it out.
     
    share
    + Quote Reply
  2. jacg, Sep 8, 2013

    jacg macrumors 6502a

    jacg

    Joined:
    Jan 16, 2003
    Location:
    UK
    #2
    I'm not in front of numbers right now but have you tried entering...

    =if(

    Pretty quickly you should get screen tips advising you of the correct syntax.

    Good luck.
     
    share
    + Quote Reply
  3. LongSticks, Sep 8, 2013

    LongSticks macrumors 6502

    Joined:
    Jul 22, 2012
    Location:
    Kent, UK
    #3
    Should work

    For anybody else!

    =if(e1="Y", L1-I1,"0")

    =(conditional, if true, if false)
     
    share
    + Quote Reply
  4. saberahul, Sep 8, 2013

    saberahul macrumors 68040

    Joined:
    Nov 6, 2008
    Location:
    USA
    #4
    syntax is generally similar to that of excels. googling if/then + excel will be of help to anyone else with similar questions.
     
    share
    + Quote Reply
  5. neutrino23, Sep 9, 2013

    neutrino23 macrumors 68000

    Joined:
    Feb 14, 2003
    Location:
    SF Bay area
    #5
    Or just search through the help documentation provided with Numbers. They include examples for nearly all functions.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page