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)

Is it like this?

Attached Files

New_Era_Live_2.xlsx (14.1 KB, 19 views)

Since when is the comma replaced by a semi-colon in functions?

For me semicolon as argument separator is standard, but it should automatically be changed to comma if you open my file in Excel with US-settings.

Did you experience something different?

No did not change to comma; I am used to comma since when MS Excel got more popular than Quantum or some name like that.

Must have to do with my location settings on my laptop

Thanks anyway - you have solved my problem