create an excel formula with contitions

C

cuvi

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.
 
G

GerryK

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.
 
Top