Nested IF(ISBLANK) Formula

[spectraflame]

I have 3 columns in a sheet titled 'Meter Data' which are formatted as a date. From another sheet within the same workbook, I would like to perfrom an IF(ISBLANK) statement. The 3 columns do not always contain the same number of dates.

My IF(ISBLANK) statement that I am trying to write goes like this.

If cell A1 in the Meter Data sheet contains a date, return that date; but if is does not, give me the date in cell G1, but if that cell does not contain a valid date; give me the date from M1 and finally if none of the referenced cells contain a date, leave the cell blank.

I have tried the following, but I cannot find my mistake.

=IF(ISBLANK('Meter Data'!A1,'Meter Data'!G1,IF(ISBLANK('Meter Data'!G1,'Meter Data'!M1,"",))))

Any suggestions would be appreciated.

Thanks,
Matthew

 

[jimboy]

Try this;

=IF('Meter Data'!A1<>"",'Meter Data'!A2,IF('Meter Data'!G1<>"",'Meter Data'!G1,IF('Meter Data'!M1<>"",'Meter Data'!M1,"")))

 

[spectraflame]

Jimboy,

That did the tirck. I have not seen that <> used in that manner before. I guess you can still learn something new every day.

Thanks again,
Matthew