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!!!!
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)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
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)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks