isblank and if

  1. L

    use of isblank returns result when value seems to be blank, but cell contains a function - way around this?

    If a cell contains a function but displays the result of that function as a blank, literally "", my isblank function reports as if it is not blank. It seems to be looking at the function not the value. Is there a way for me to specify to isblank that I want it to look at values alone? Thanks.
  2. SkywardPalm

    TEXTJOIN IF ISBLANK

    I am attempting to pull the categories that names are found in, and have it working all but for blank/missing names. =TEXTJOIN(", ",TRUE,UNIQUE(IF(ISNUMBER(SEARCH(A1,'Master'!C:C)),LEFT('Master'!A:A,4),""))) The cell "A1" is blank, and I am trying to pull the results (first 4 left characters...
  3. V

    How to get Total count in a column excluding Blank Cells in a formula..

    Dear Friends, I need a little help on this. I have entered formula to make a cell return a value when the data is available on other cell. In the attached excel sheet, I have dates in column E. There are some cells where the date will not be available. I wrote a formula in column F...
  4. A

    NOT(ISBLANK) Issues

    Hello all, I have created this piece of work and seem to have an issue.. =IF(ISBLANK(A5),"",IF(C5="Rinsed","Rinsed",IF(AND(NOT(ISBLANK(R5)))*AND(NOT(ISBLANK(S5)))*AND(NOT(ISBLANK(T5)))*AND(NOT(ISBLANK(V5)))*AND(NOT(ISBLANK(AK5)))*AND(NOT(ISBLANK(AN5))),"Pass","Fail"))) What I am looking for...
  5. W

    Using if and ifblank

    Hi Everyone, I've been trying a number of different combinations but nothing is working so far. I am trying to do a formula that if a cell is blank then to do a sum. The "sum" part works fine: =IF(G3>3,"yes","no") but what I can't do if for it to only perform the sum where the cell is blank...
  6. K

    Need formula to return the earliest Date with the first blank "$ Amount" field that matches a specific ID

    Hi! I have a spreadsheet that we use to track contracts, Purchase orders, and Invoices/payments. I am trying to create a field that will show me the next soonest invoice date that doesn't yet have a dollar amount populated (because that date is the next invoice that we haven't yet paid... the...
  7. F

    Several blanks, need to fill consecutively based on if and isblank statements

    Trying to fill a column per these rules: IF [Major] ISBLANK use [Super] IF [Super] ISBLANK use [Client] IF [Client] ISBLANK use I just tried the following, but was told there are too many arguments: =IF(OR( [Major]="", ISBLANK( [Major] )), IF(OR( [Super] ="", ISBLANK( [Super])), IF(OR(...
  8. 2

    Multiple ISBLANK Query

    <colgroup><col><col><col><col></colgroup><tbody> ORDER STATUS CAD PENDING DIE PENDING STONE PENDING CAD PENDING </tbody> These are my 4 columns, if (Column 2,Row 2) -> CAD pending cell is blank , then Order status(Column1,Row2) should show CAD PENDING, if (Column 3,Row 2), DYE PENDING is...
  9. S

    Cell is Blank/Null yet IF(Cell ="" , "" , "Do Something") Always Renders "Do Something"

    I'm working on a file to pass to others to fill out. There is a hidden worksheet that references filled out worksheet. I'm using OFFSET to try and minimize errors if entries are moved around the visible worksheet. I need to append text to one cell, but because the worksheet will be uploaded to...
  10. H

    Formula help, please

    =IF(J2>75,"3",IF(J2>65,"2",IF(J2>50,"1",IF(ISBLANK(J2),"none","0")))) J2 column holds the scores to a conditional test. Not everyone was given the test so there are some blank cells. IF the cell is blank them "none" belongs in the column if the cell has a number in it then the first IF...
  11. D

    vlookup with isblank

    Hi Hope you can help me below is a formula that is in 4 different cells obviously recalling a clients data into cells once the client number is chosen in E4, what I need is to adjust it so that if there is no client chosen yet in E4 that the corresponding cells be blank and not have the #n/a in...
  12. K

    If isblank today()

    Greetings to Tech Gurus, I'm seeking help in nesting a formula but ending up with an error. Please see below details for my formula nesting. C3= % (this cell will have number up to 100 in %) F3= Date (this cell will have date in MM/DD/YYYY format) G3= formula (below is the formula which i'm...
  13. L

    Past due dates

    I have a sheet that I am trying to calculate days past due. I=Date Due J=Days Past Due K = Date Implemented I want to calculate the days past due, stopping counting once the date implemented is entered and I need to ignore blank cells. I have a formula that works to stop counting after the...
  14. N

    Finding Blank Cells in a Dynamic Range: VBA

    The following code of mine is not running: Sub Blank_Cell_Alert() Range("A2").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Name = "MyRange" ActiveSheet.Name = "MySheet" If...
  15. M

    Need to have #value return a zero value

    Good morning everyone. I am looking to see if I can adjust my isblank statement so that when it gives an error (#VALUE) it turns to a zero. This is what I have now: =IF(ISBLANK(V40),(U40*X40),(V40*X40)) Is this possible?
  16. G

    Conditional Format ISBLANK NOT AND IF ?? based on 2 cell values

    Hello Any help is much appreciated! I have a spreadsheet where I log materials invoices and I would like to highlight a cell if it contains the supplier but I have forgotten to enter the invoice amount (and vice versa). So if I have an invoice for Smiths and I enter the Supplier in A2 but if...
  17. C

    To find column that is blank

    Hi everyone, Im working on a spreadsheet that contains many columns. I like to know if there is any function or ways to know the column no contains no value or blank cells. Please advice and thank you very much. I tried using if and isblank funtion, but it does not seems to work. <tbody> A...
  18. 4

    Calculate IF AND formula only is cell is not blank

    Hi all! I am trying to return one number if an cell is greater than an amount and another if it is less than and generate nothing if the cell is blank. I have tried several manipulations of this and I just cant seem to get it right. Here are the stats If E2 is blank return " " If E2 <=9000...
  19. B

    Is there a way to have a cell, which contains a formula, be classed as a blank cell?

    I am creating excel file in which i want to calculate my online orders to generate profit report. i am getting #value error. I want "L" cell to remain blank if "J" is blank. I know if cell contains formula then it is not considered as blank. Please tell me how can i solve this issue. Is there a...
  20. D

    If, or isblank, min

    I want a formula that will read multiple columns. IF the column ISBLANK I want it to go to the next column on the list. IF that column has a value then, move to the next column till all are read. At the end of the process I want it to READ all columns and return the minimum value (which would...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top