Hello,
I'm trying to re-write the following formula without extending it too long each time the year increases. What would be the way of doing it without having to create too many nested if?
Formula:
Please Login or Register to view this content.
Thank you.
I found this one, which actually works but I'm sure there is another way if M2 had no "fyXX" in it.
Formula:Please Login or Register to view this content.
Having to make a wild guess here based on what you've told us:
=IF($M2="", "","FY"&LEFT($M2,2))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks AliGW. Indeed, it is another way for writing it. I'm wondering if there is a way to increment without a very long nested if though - say, if M2 = 1 and increments so the corresponding value would be FY18 (for M2 = 1), FY19 (for M2 = 2), etc.
Thank you
Try:
=IF($M2="", "","FY"&(17+$M2)
Quang PT
Thank you all very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks