IF statements- HELP needed. Please :)

J

Joel Childs

Hi everyone!

This is my first post here. Im having a little bit of trouble with an "IF
statement" in Microsoft Excel 2003- Hopefully I can find some help. :) My
question is how should I format my if statement when im aced with this
scenario: If the value in D8 is between 1500 and 2499 enter "50", if not
enter "0". Thanks for the help!

Joel :)
 
S

smartin

Joel said:
Hi everyone!

This is my first post here. Im having a little bit of trouble with an "IF
statement" in Microsoft Excel 2003- Hopefully I can find some help. :) My
question is how should I format my if statement when im aced with this
scenario: If the value in D8 is between 1500 and 2499 enter "50", if not
enter "0". Thanks for the help!

Joel :)
Click to expand...

Welcome Joel!

Try

=IF(AND(D8>=1500,D8<=2499),50,0)

Hope this helps!
 
Top