#1
|
|||
|
|||
"IS" functions mixed with IF
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 |
#2
|
|||
|
|||
"IS" functions mixed with IF
Is it like this?
|
#3
|
|||
|
|||
Thanks; problem solved
Since when is the comma replaced by a semi-colon in functions?
|
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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 |
Tags |
functions, isblank |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to restore custom functions from a corrupt ".xlam" file ... | gamouning | Excel | 1 | 11-12-2015 11:03 AM |
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
'Linking' entered information to other "cells" from an original "cell" in MS Word | Wade | Word | 6 | 09-03-2012 05:22 PM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |