re: Multiple If Statements

[twildone]

re: Multiple If Statements

Hi, I am trying to create a summary sheet where it reports the results from the most recent month. I have a worksheet for each month. I have tried to use the following formula and I get a response of FALSE. Not too sure if this is the best way but thought it might work...any suggestions...thanks

=IF('Mar Finance'!C4="",'Feb Finance'!C4,IF('Feb Finance'!C4="",'Jan Finance'!C4,IF('Jan Finance'!C4="",'Dec Finance'!C4,IF('Dec Finance'!C4="",'Nov Finance'!C4,""))))&IF('Nov Finance'!C4="",'Oct Finance'!C4,IF('Oct Finance'!C4="",'Sep Finance'!C4,IF('Sep Finance'!C4="",'Aug Finance'!C4,IF('Aug Finance'!C4="",'Jul Finance'!C4,""))))&IF('Jul Finance'!C4="",'Jun Finance'!C4,IF('Jun Finance'!C4="",'May Finance'!C4,IF('May Finance'!C4="",'Apr Finance'!C4,IF('Apr Finance'!C4="",""))))

 

[baitmaster]

Re: Multiple If Statements

Whatever else you might try, this is not the most efficient way to do it!
If it was me I'd consider using =INDIRECT("'"& [calculate month here] &" Finance'!C4")