Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page