isblank

  1. B

    Sheetoffset help needed

    I am using the sheetoffset formula that has been written about previously on this site. I would like to input the value for a cell from the sheet next to it if it has been left blank on the original sheet. Here is the code for the sheetoffset function: Function SHEETOFFSET(offset, Ref) '...
  2. L

    IsBlank function run on form will not allow initial save of bank value to send to users

    I am having an issue with a similar request. I need to send my excel sheet to the user with blank cells to be filled in. Once the user opens this book I need to prevent the user from being able to save the workbook without the specified cells filled in. (This portion I have code that works for...
  3. H

    IF Cell is blank, use COUNTA formula.

    Hi Folks, Excuse my stupidity, I have a fairly straightforward excel formula question. I am trying to use the following formula: =IF(ISBLANK('Contract Compliance Month 3'!F38:F39),COUNTA('Data Sheet'!D7:D64)) if a certain cell, F38:F39 is filled, run the counta formula and display the total...
  4. T

    Conditional Formating - Column and Row Highlighting

    I have a query relating to conditional highlighting - specifically highlighting a cell's column and row based upon whether it contains data or not i.e. if it is blank, it's column and row remain unhighlighted, but when it contains data, it's column and row should become highlighted. I could...
  5. K

    Sumifs & isblank

    Hi - I am trying to create a condition in a SUMIFS function that looks at works as follows: A B C D (Date) (estimated) (actual) (quantity) 1 9/1/13 9/1/13...
  6. K

    If statement within sum if string of conditions

    I am trying to have excel look at numerous conditions an return a specific number. I have been able to use SUM IFS but have hit a snag. The condition I am trying to apply is whether the number in column on given Sheet (SHEET1'A1:A100) matches the number in my reference column on a separate...
  7. J

    Complicated ISBLANK Cell Formatting Question

    Hello, Typically I would grind away for hours trying to solve the problem myself, that way I will never forget how to do it again, but this time, I don't even know where to start! Little confusing to explain, but here is my best shot: In order to keep my table neat, I have the following...
  8. L

    Null Value

    I know this may be a stupid question, but in VBA does Null mean blank? I am looking at using the logic IsNull and am wondering if that is the same logic as =IsBlank() for a cell formula.
  9. S

    Array formula to count occurrances with three conditions.

    Hello, I have the following array formula: {=SUM(IF(ISNUMBER(FIND(A37,Data!G:G,1)),IF(ISBLANK(Data!C:C),IF(ISNUMBER(FIND("MSP",UPPER(Data!B:B),1)),0,1),0),0))} In layman's terms it says: count the number of occurances where the text in cell A37 is found in column G, a BLANK is in column C and...
  10. M

    Array Formula with ISBLANK

    I'm working on an array formula for dollar amounts and autofilling the necessary phrases based on a financial threshold. If amount in K3 is equal to or over $100,000, populate “WALT” in U3 If amount in K3 is less than $100,000, populate “MIKE” in U3 If K3 is blank, U3 remains blank I believe...
  11. D

    SUM of Dropdown Selection; ISBLANK Statement

    Good Morning/Afternoon, In L3, I have a dropdown list of dates by year (2005-2012). The formula I want to use for Z3 will add 5 years to the current displayed date in L3. Right now, I have that listed as =SUM(L3)+5, but want to nest an ISBLANK statement in there for when L3 does not have a...
  12. H

    Conditional formatting based on past and future dates

    Hi all, I'm struggling to know the right order to put the conditions in, if anyone could help please. I would like empty cells to stay blank/white Any cells with dates in the past or in the next two weeks (i.e past due or due soon) to turn RED Any dates not due in the next two weeks can stay...
  13. R

    ISBLANK insertion needed

    I have a formula listed below that works searches the identified column, the highlighted larger font section, has blanks I would like it to recongnize, because it will be sheet that is constantly replaced I do not want to add "" or 0, but recognize the actual blank cell, a column with...
  14. D

    Difficulty with IF, ISBLANK Formulas and Conditional Formatting in Excel 2010

    Hi there, First, thanks in advance for any help. I am working on an MS Excel 2010 spreadsheet that tracks attendance records. If students miss two or more days in a row, I need to follow up on it. My goal is to create a status column for each student where the cell will turn red if they miss...
  15. K

    Getting a very complicated formula to calculate only if NOT(ISBLANK)

    H4 is a date/time stamp I have saved as a macro. Returns 12/28/2011 10:47:00 AM. I4 is the same macro and returns 12/28/2011 10:48:00 AM J4 calculates the difference between the two (I4-J4), but only recognizes business hours and business days (Monday-Friday, 8:00 am to 5:00 pm) I only want...
  16. E

    ISBLANK not working/malfunctioning

    I'm going mad trying to figure out the issue. ISBLANK is returning FALSE for a seemingly blank cell. The formula is: ISBLANK(VLOOKUP($A13,data1,COLUMN(C:C),TRUE) I thought it has something to do with the VLOOKUP returned value. However,when I press delete on cell A13, the problem is fixed...
  17. C

    IF ISBLANK Function help

    Hi Everyone I dont know if its because I havnt used excel in a little while or because its late but i'm trying to write a formula that says IF Cell 1, 2 OR 3 is NOT blank then return the value of "1" but it doesnt seem to be working. I tried the below but only when something is in D10 does it...
  18. C

    Sum up to next blank row

    Does anyone know of a formula (variable – not locked) that will find the sum of the rows above up to the next blank cell/row? IE: I have a very large spreadsheet full of data that are broken up into separate sections (quarters/semesters/months) – they are “broken”/separated by a blank row...
  19. M

    Nested IF and ISBLANK formula needs work...

    Ok the boxes in red need to be cleared if there is an amount in the blue boxes. Please help. Been trying to find an answer to this since the 19th... Code for Red box is =IF(ISBLANK(B4),"",IF(A4="I",130,IF(A4="T",100,IF(A4="S",75,IF(E4="<>0",""))))) Code for the Blue box is...
  20. B

    Need help with a formula!

    Hi, I have 2 columns. In each row either both columns are blank, or only one of the columns has a text or a number. I am trying to have 3rd column with any number or text from either of the columns. I am using the following formula but it is wrong...

Some videos you may like

This Week's Hot Topics

Top