create an excel formula with contitions
 

I am trying to create a formula that will show contents of a cell from
another page in a workbook. The conditions are if the cell has times in it,
show the times but if it has nothing remain blank.

Put this in Sheet 1 A1
=IF(ISNUMBER(Sheet2!A1),Sheet2!A1,"-- ")
Sheet 2 A1 has your time (eg. 1:30) then format Sheet1 A1
as Time, result will be 1:30:00 AM.

-----Original Message-----
I am trying to create a formula that will show contents
of a cell from
another page in a workbook. The conditions are if the
cell has times in it,
show the times but if it has nothing remain blank.
.