-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
isblank()
-
R
ISXTYPE
ISXTYPE, companion to XTYPE, is a powerful alternative to Excel's built-in type-based conditional functions such as ISNUMBER, ISTEXT, etc., while packing other useful features as well ISXTYPE was designed to provide conditional output after assessing the precise and high-resolution data type of...- Rnkhch
- Thread
- blank data type error error types isblank() iserror() islogical() isnumber() istext() logical number text type
- Replies: 2
- Forum: Excel LAMBDA Functions
-
T
Combined conditional logic with ISBLANK function
I am trying to build a function that gives one of two text outputs in one column (W). I want columns K-U to return “Placement Info” if any of the cells are not blank. I also want the same formula to return the same “Placement Info” response but only if columns J AND I are not blank. Otherwise...- ToadinHole
- Thread
- isblank()
- Replies: 1
- Forum: Excel Questions
-
L
Problem with ISBLANK() functioning
<tbody> in 8:00 8:00 out 12:30 12:15 in 13:30 13:15 out 17:30 total 8:30 6:37 15:37 15:37 </tbody> function for the first total (in cell B10)=IF(ISBLANK(B6:B9),"0",IF(ISBLANK(B7:B9),NOW()-B6,IF(ISBLANK(B8:B9),B7-B6,IF(ISBLANK(B9),(NOW()-B8)+(B7-B6),(B9-B8)+(B7-B6)))))...- Laura Roberts
- Thread
- isblank() nested if() now() timesheet total
- Replies: 5
- Forum: Excel Questions
