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="",""))))
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="",""))))