IF statements- HELP needed. Please :)
 

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 :)

IF statements- HELP needed. Please :)
 

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!

IF statements- HELP needed. Please :)
 

Another way:

=AND(D8=1500,D8<=2499)*50

--
Biff
Microsoft Excel MVP


"smartin" wrote in message
...
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!