| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement with OR
Hello,
I need an statement that will let me put some values in a cell based on a comparison of a month in one cell. I have that part correct, however I would also like to look to see if another criteria is met. For instance, the month falls between a range of begin date and end date. How can I do that with an if statement? Thanks =IF(OR(MONTH(Sheet2!$D$4)=Sheet4!J2,Sheet2!$I$4/Sheet2!$J$4,0), IFMonth(Sheet2!$d$4) Sheet4!J2,Sheet2!$i$4/Sheet2!$J$4,0)) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement with OR
however I would also like to look to see if another criteria is met. For instance, the month falls between a range of begin date and end date. It sounds like you need to look into the AND function rather than OR. AR |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement with OR
=if(And(A1=B1,A1<=C1),"Between","Not Between")
-- Regards, Tom Ogilvy "trobinson" wrote: Hello, I need an statement that will let me put some values in a cell based on a comparison of a month in one cell. I have that part correct, however I would also like to look to see if another criteria is met. For instance, the month falls between a range of begin date and end date. How can I do that with an if statement? Thanks =IF(OR(MONTH(Sheet2!$D$4)=Sheet4!J2,Sheet2!$I$4/Sheet2!$J$4,0), IFMonth(Sheet2!$d$4) Sheet4!J2,Sheet2!$i$4/Sheet2!$J$4,0)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Linear Mode
