Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula help please (Office XP)

    Good afternoon

    I though this was quite simple but I must be doing something wrong somewhere

    =IF(A11<20,D9=20,IF(A11>20,D9=A11,"")

    Any help appreciated

    Stephen

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula help please (Office XP)

    If you want to place a result in cell D9, you must put the following formula in cell D9 itself:
    <code>
    =IF(A11<20,20,IF(A11>20,A11,""))
    </code>
    The result will be
    20 if A11 is less than 20
    blank if A11 is equal to 20
    the value of A11 if A11 is greater than 20

    If you want something else please explain.

    You cannot set the value of D9 by placing a formula in another cell.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •