Joel Childs wrote:
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 :)

Welcome Joel!

Try

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

Hope this helps!