HELP FRIENDS!

[CHARODIAZ]

Hi! I´m a bit desperate, I need to use an IF formula where I not only have multiple variables but I need 3 possible outcomes not 2. And, granted, I might be to tired to think logically at this point!
So I´m doing a financial analysis where it´s important to know how many months are in the period when it begins and when it ends. Because projects start and finish at different times of the year. So I know that for the first cell I can use =13-MONTH('Project Set-up'!G12) (where G12 is the start date), and I know that all subsequent years are gonna be 12 months (so everything in between start and end date), but then I need to tell it to be zero in those cells that are greater than the end year of the project and to also calculate the months left on the exit year of the project.

Oh man! I hope I make sense, however thanks for the input!

 

[S Oberlander]

Did you ever use nested ifs?

Instead of 13-MONTH('Project Set-up'!G12)
Try:
IF(13-MONTH('Project Set-up'!G12)>"end year of the project",0,13-MONTH('Project Set-up'!G12))

(replace "end year of the project" with whichever cell has the necessary info)

 

[CHARODIAZ]

Did you ever use nested ifs?

Instead of 13-MONTH('Project Set-up'!G12)
Try:
IF(13-MONTH('Project Set-up'!G12)>"end year of the project",0,13-MONTH('Project Set-up'!G12))

(replace "end year of the project" with whichever cell has the necessary info)

Oh my god, I´m just seeing your message, it took me a good hour to figure it out. I hadn´t used IFS before but it worked like a charm.
Thanks for being so quick in replying and for sharing your knowledge. Much appreciated.