ifblank

Hi all, Longtime lurker/reader, first time poster! I'm looking for some help creating (for me) quite an advanced excel formula. I think any separate part of this i'd be fine with but combined together has somewhat melted my brain. Any help would be greatly appreciated, new to forums so let me...

Hi all. OK, so I will try and explain this: I have a spread sheet for auto working out, Percentage, Then PASS & FAIL. I would like the PASS and FAIL cell to stay blank if nothing is put into the SCORE cell. (Score cell is a drop-down option) So, when from the SCORE drop down is entered, It...

Hi all, I have the following formula: It checks if the cell in C9 is blank (which it is not, the text is just hidden) and then returns the current date of today. However, I am also referring to cell C7 in another cell, specifically like this: My issue is, obviously, that the cell...

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

Hi all! I have this formula: But for some reason, my formula does not work? I want my formula to return "NOT BLANK AND NOT 1" if the cell contains a value that is not = 1 and not a blank cell. If the cell contains the value 1 or is blank, i want my formula to return a blank cell. Can...

Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...

I am trying to troubleshoot the following formula =IF(ISBLANK($J4), SUM($K4+30), SUM($J4+30)) where J4 & K4 are date fields. When a date is is not entered in either J4 or K4, this formula displays dates based on the year 1900. How do I fix this to show a blank cell? Thank you in advance. Roy

I have this code which filters for "RET" and then goes to next active cell. But in case "RET" is not found in the list, the next active cell will be blank and I want it to do nothing and continue on another part of the code and if it is not blank I want it to replace "RET" with 0...

Hi, I'm new to this forum and signed up in the hope someone could help me with something I've been trying to figure out for hours without success, including going through the forum here, searching for IFBlank - maybe that's what I don't even need. My data set looks like below with Q1_round1...

Hello Everyone, I searched everywhere and I can't seem to find the answer to my problem and to be honest i don't know if this is even possible. I run a huge family "NFL Pick the Winners" spread in Excel, about 18 of us. I was hoping I can use conditional formatting to change the color of...

I am trying to get a formula so that if cell H is blank then return the information from cell B. For Example H2 is blank I would like Credit One to be the returned value in Cell B35. I was thinking a count if formula but I am having trouble getting it to pull the correct data.

Hi, I have a simple spreadsheet where I am copying over data from another sheet called 'Master Tracker' in the workbook, so each cell is just a basic ='Master Tracker'!A5 etc. However where some of the cells are blank, I want the cells on my other sheet to also appear blank instead of a zero...

Hi, I am using the following VBA script to combine my worksheets but am having an issue b/c there are formulas in each worksheet running the entire column (columns A and D). I want to combine only the rows where the B column is not blank. Any help in modifying the macro would be much...

I'm trying to create a formula out of this: If an item has not been sold then the sold column will be blank. If it is blank then I want to take the figure out of the price paid cell and put the total of all unsold items into one cell to generate a running total of stock. I can do this with...