This one's been frying my head. I have a formula that displays a value from a cell (D12) if a date in a different cell (C12)falls before a date from a third cell (F2). That's the easy bit, what I want to do is to have the cell only display the value if the month in the second cell is an even number and to be blank if its an odd one. Is this possible and if so how? Thank in advance for any help, the formula I'm currently using is;
=IF(C12<=F2,D12,"")
Take a look at seeing if you can modify this to your use?
=iseven(MONTH(cell-ref))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you FDibbins, I added that formula to another cell, moved my original to F12 (and hid both of those cells) and used =IF((E12=TRUE),F12,"") in the cell I wanted the value in. So glad to finally have this working, thanks again for your help.
Great stuff and thanks for the feedback and kind words
You could have also used
=IF(E12,F12,"")
Also, maybe put the whole thing in 1 cell?
=if(formula-in-E12,F12,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks