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