Hi,

I am using Office 2007 on Windows 10 (which was difficult to get installed)

I am trying to use ISBLANK within an IF function:
=IF(ISBLANK(C4),"Empty",((C4-C3)/100))

C4 is an end time and C3 a start time. When I only use the "(C4-C3)/100)" part of the function without an end time, the result is an unattractive value that is visible to the user. When the end time is entered everything looks nice. I want the function to show nothing when the end time is not yet entered (i.e. "" - I am using the word Empty to debug).

When I enter this function, Excel informs me that there is an error in the function.

Excel help did not help me to clarify what I am doing wrong.

Any help from you?

Phlip

Attached Files

New_Era_Live.xlsx (13.5 KB, 13 views)