Hello,
I also have a problem with an "if" formula. As you can see in attached sample, i have a range of months, and I extracted the year using a MID formula. However, in our company the Fiscal Year begins in October, so 200710 should already be 08, 200810 - 09, and so on. How could I introduce an "if" formula (or something else), so that I can turn months into FY?
Many thanks in advance for your help.
Last edited by baby_mic; 03-19-2010 at 08:35 AM.
Hi and welcome to the board
I don't quite follow your logic. Could you please enter a few examples in your sheet of what you want to obtain?
Thank you for your interest in my problem.
I added some examples to my file, I hope I managed to be more specific and clear this time.
Hi,
Take a look at attached file ...
HTH
Last edited by JeanRage; 04-05-2010 at 07:54 AM.
Hi,
if the result needs to stay as text try the following in G13 ( referring to your posted sheet)
=IF(RIGHT(F13,2)*1>=10,CONCATENATE(LEFT(F13,4)+1,RIGHT(F13,2)),F13&"")
Another variation of arthurbr's approach might be:
=RIGHT(LEFT(B3;4)+(RIGHT(B3;2)>"09");2)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thank you both for your suggestions, they worked just fine. Thank you also for the quick reactions. Have a great and sunny weekend
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks