Excel 2007 : IF Statement/VLOOKUP

**trecbone** · 02-18-2010, 11:06 PM

I need some help. I am working on a worksheet titled "Budget Summary" and need a statement in cell C19 that says if cell B2 says February, April, June, August, October, or December, than it will give me the result on a worksheet titled "Depreciation", cell G5. If a different month/value is displayed in cell B2 than I need the cell (C19) to display a zero. I'm new at this and have fiddled around with IF and VLOOKUP and have had no luck. Please help!!!!

**Palmetto** · 02-18-2010, 11:27 PM

If the value in C19 is text, use
=IF(OR(B2={"February","April","June","August","October","December"}),Depreciation!G5,0)

If the value in C19 is a date, use
=IF(OR(MONTH(B2)={2,4,6,8,10,12}),Depreciation!G5,0)

**DonkeyOte** · 02-19-2010, 03:47 AM

Yet another alternative:

=IF(MOD(MONTH(B2),2),0,Depreciation!G5)

If B2 is Text then

=IF(MOD(MONTH(1&B2),2),0,Depreciation!G5)

Given use of XL2007 you could substitute MOD(...,2) for ISODD(...) if preferred (pre XL2007 this requires activation of Analysis ToolPak)