| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statements | Excel Worksheet Functions | |||
| how to do if and or else statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| using IF THEN statements | Excel Discussion (Misc queries) | |||
| If statements | Excel Worksheet Functions | |||
Linear Mode
