# Thread: IF formula (XP)

1. ## 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. ## Re: IF formula (XP)

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

Steve

3. ## Re: IF formula (XP)

Try

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

4. ## 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. ## Re: IF formula (XP)

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

6. ## 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>

7. ## Re: IF formula (XP)

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

8. ## Re: IF formula (XP)

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

9. ## Re: IF formula (XP)

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

Steve

10. ## Re: IF formula (XP)

Ah, if only I were so foolish.........

#### Posting Permissions

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