Results 1 to 10 of 10

Thread: IF formula (XP)

  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    IF formula (XP)

    Goof morning
    I have a blank and can't see the obvious
    Trying an IF formula that says <if the content in cell D3 is bigger then 90 but smaller then 200 the answer is "3", outside this range the answer is 0
    I came up with this but I know its wrong =IF(D3,">80,3",">200,0")
    Thanks in advance
    Karat

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: IF formula (XP)

    <pre>=if(and(d3>90,d3<200),3,0)</pre>


    Steve

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

    Re: IF formula (XP)

    Try

    =IF(AND(D3>90,D3<200),3,0)

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: IF formula (XP)

    <img src=/S/smile.gif border=0 alt=smile width=15 height=15>We seem to be sending answers at the same time on both the excel board and the puzzle board...

    Steve

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

    Re: IF formula (XP)

    Great minds... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  6. #6
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF formula (XP)

    To complete the saying, to give it its full justice:

    Great minds think alike: fools seldom differ! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

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

    Re: IF formula (XP)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> !

  8. #8
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: IF formula (XP)

    Thanks guys...
    and yes, great minds
    Thanks again

  9. #9
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: IF formula (XP)

    Ditto: <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

    Steve

  10. #10
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF formula (XP)

    Ah, if only I were so foolish.........
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

Posting Permissions

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