Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Setting a cell to react to certian conditions

Discussion in 'Information Technology' started by Rob, Nov 6, 2005.

  1. Rob

    Rob
    Expand Collapse
    Guest

    I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16. If
    c16>0, then e14=0
     
  2. Loading...

    Similar Threads Forum Date
    General Great Production of English Songs and scene settings Videos Oct 11, 2012
    Hinduism Why is there Dancing in Bhajans or in Mandir Settings? Interfaith Dialogues Feb 18, 2011
    Personal Goal Setting. Why Set Goals? Business, Lifestyle & Leisure Oct 23, 2010
    Rise in Extremism or Rise in Hysteria? Canadian Sikhs Setting the Record Straight Hard Talk Apr 25, 2010
    Sikh News Badal invited to Pakistan for setting up of Nanak varsity (New Kerala) Breaking News Nov 23, 2009

  3. Dr Alok Modi MD

    Dr Alok Modi MD
    Expand Collapse
    Guest

    You could use the case function or iif function.

    Dr Alok Modi MD

    "Rob" wrote:

    > I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16. If
    > c16>0, then e14=0
     
  4. Rob

    Rob
    Expand Collapse
    Guest

    I tried usung"if", but how do I get the the cell c14 to actually perform the
    function, not just return a true or false value?

    "Dr Alok Modi MD" wrote:

    > You could use the case function or iif function.
    >
    > Dr Alok Modi MD
    >
    > "Rob" wrote:
    >
    > > I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16. If
    > > c16>0, then e14=0
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Sounds as though you're talking about Excel, in which case you should post
    your question to a newsgroup that deals with Excel.

    This newsgroup is for questions about Access, the database product that's
    part of Office Professional.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)



    "Rob" <Rob@discussions.microsoft.com> wrote in message
    news:64BC04CB-F0FA-4C93-9203-88AB09C03067@microsoft.com...
    >I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16.
    >If
    > c16>0, then e14=0
     
  6. Ofer

    Ofer
    Expand Collapse
    Guest

    Hi Rob
    It sound like an Excel question, this is Microsoft Access discussion group,
    and in access we refer to cell as fields and records.

    In Access your answer will be
    e14 = iif( c16<=0, c16, 0)

    But if it is Excel question, you can try Microsoft excel discussion group
    --
    The next line is only relevant to Microsoft''s web-based interface users.
    If I answered your question, please mark it as an answer. It''s useful to
    know that my answer was helpful
    HTH, good luck


    "Rob" wrote:

    > I tried usung"if", but how do I get the the cell c14 to actually perform the
    > function, not just return a true or false value?
    >
    > "Dr Alok Modi MD" wrote:
    >
    > > You could use the case function or iif function.
    > >
    > > Dr Alok Modi MD
    > >
    > > "Rob" wrote:
    > >
    > > > I need to set 1 cell to meet certian conditions. ex. c16<=0, then e14=c16. If
    > > > c16>0, then e14=0
     

Share This Page