1. W

    Exact formula to ignore blanks

    Hi, I'm looking for a formula to compare differences between two columns (A & B), so that it returns a comment - "No change" or "Difference" - in column C. But I would like the formula to return a blank (or a statement to say "Fine") if the value in column A is also blank. Essentially, I need...
  2. 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...
  3. MrDB4Excel

    IF(ISBLANK Returns #VALUE!

    In this workbook, I have tried in vain to get cells to show nothing when there is no value in specific cells. Cells A2 to A8 show a date while cells A9 to A11 are blank. Cells C2 to C11 has the formula =IF(ISBLANK(A2),"",A2); obviously each successive row the row number changes, for example: In...
  4. Jyggalag

    Conditional formatting for blank cells containing formulas?

    Hi all, I currently have this setup: I have a row of formulas saying IF(ISBLANK(cell below),return blank value, otherwise return value to the left + 7) to advance the week one week ahead when data is entered. I want to create a conditional formatting for this row, so whenever a value is...
  5. I

    How to merge two formulas in to one formula

    Hello Excel specialists, I have two formulas I would like to merge: First formula =IFERROR(VLOOKUP($A8,List2!A:T,9,0),"Value not found") This formula is checking if cell value of A8 exists in List 2 Second formula =IF(ISBLANK(VLOOKUP($A8,List2!A:T,9,0)),"Empty",VLOOKUP($A8,List2!A:T,9,0))...
  6. Z

    need help with countif formula

    hi, i have a table called mytransaction. in this table there is a column, R, to indicate the user has checked on the transaction. there is also another collumn call source where they select which account is involve in that transaction. so now in one of the cell i would like to count how many...
  7. S

    First NotBlank Column C and First Blank Column E

    Hi folks, I am looking for a VBA to search two column in a worksheet. As the title suggests, I would like the code to find the first non-blank in Column B (it will be text, if that makes a difference) Once it finds the first non-blank in Column B, it should look to see if Column E is Blank...
  8. M

    Prevent entry in cell i cell is not blank

    Hey Is it possible to use Data Validation to prevent someone from overwriting text in cell if there is already text in it? So that the cell has to be cleared before you can type in something new? I've tried =NOT(ISBLANK(A1)) and a few other formulas, but none worked. Regards Mads
  9. M

    Use the Isblank & Iferror Excel function With Date/Time Cell reference

    Hello, I'm ashamed to say having a harder a much time then I hoped to create an excel formula for a work report and ask the experts fo your help. Please! I have a straight forward excel table and reference a date/time/AM/PM from one cell and perform a text string function to break out the...
  10. 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...
  11. M

    isblank and istext both return false

    Dear All! I've encountered a curiousity. A SAP download contains description within cells J to O. Both formulas, isblank and istext return "false". My goal would be to detect empty cells for deletion. All cells are formated manually as text and no value is shown when entering the cell...
  12. H

    How to cancel VBA code execution if cell ISEMPTY

    Im having a little trouble finding the correct syntax to stop macro, if certain cell is left unfilled. The code is following, which extracts certain bit of info from the excel sheet and saves to txt file. Private Sub Interactive Button to press() Dim wb As Workbook Dim saveFile As String Dim...
  13. H

    Highlight Blanks and not "spaces" - conditional formatting

    Hey there, i am trying to highlight if a cell is blank, but don't want " " (a space) to be considered a blank cell. I tried adding a ' before the space, and this doesn't work. Any ideas? isblank and not " "
  14. M

    HELP with IS BLANK statements

    Hello, I am trying to create a formula that will do; If C2 AND D2 AND E2 contain text (date format) then "READY" else "BLANK" in another cell. If any of the three cells have a date it still needs to show blank, only when all three have a date can it show ready. I have tried various If...
  15. J


    hello I have this formula =INDEX(Holidays!$A$4:$OE$92,MATCH(O66,Holidays!$A$4:$A$92,0),MATCH($Q$54,Holidays!$A$3:$OE$3,0)) I need to include if O66 is blank, how would I do that than you Jason
  16. L

    ISBLANK question conditional formatting

    Hi, I have a lot of dates from D3:D54. I would like to set up conditional formatting to show them red if they are past due. How can I make the blank cells not show any color format? I must be close but am just missing something. I've tried searching with no luck. ISBLANK(D3,"")=IF(D3<TODAY())...
  17. J

    Combo of ISBLANK and MIN formula

    Hello, I used the below formula to pull in the earliest date found in different cells...
  18. B

    ISBLANK Formula Returns #VALUE if field is blank

    I am still learning ISBLANK, IFERROR, etc. On the below how do I change formula that will return a blank result if Cell B5 is blank?
  19. N

    Nesting 3 functions IFERROR, VLOOKUP, ISBLANK

    So I hope that I can explain this clearly. So I am trying to nest three formulas, IFERROR, VLOOKUP, ISBLANK. The goal that I am trying to achieve is use the vlookup function along with the IFERROR to not get N/A where there is nothing for the function to lookup. That has been achieved but, if...
  20. M

    Help with isblank

    Bit of a novice here so please bare with me. Trying to use an ISBLANK formula like so: =IF(ISBLANK(B26),"","Food Cost: "&B26) B26 is the cost of food. I want this formula to tie into a text line and reference both "Food Cost and cell B26 together. For the life of me and cant get this to work.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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