# Make A Cell Blank If Another Cell Is Blank?

Sep 26, 2008

Make a cell blank if another cell is blank? This is my formula, it checks two dates. It is in cell M5.

## If/then To Make Cell Blank

Jul 22, 2008

I am using a “borrowed” formula from a coworker that I do not really understand however it is working for me, sort of.

=+IF(ISERROR(FIND("F",UPPER(CONCATENATE(\$V17,\$W17,\$X17,\$Y17,\$Z17,\$AB17,\$AC17,\$AD17,\$AO17,\$AZ17)))),I F(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UPPER(\$R\$2),"NA",""),"FAIL",""),"PASS",""),4)="FFFFFFFFFFFFF FFFFF","FAIL","PASS"),"FAIL *")

What this does is read the range of cells and immediately fails a quality check if it is in a critical cell, or fails if multiple non critical items fail.

I want to use an if/then to make cell blank if there is no data in one particular cell (which means no quality inspection performed). Here is what I tried:

IF(V18="","",+IF(ISERROR(FIND("F",UPPER(CONCATENATE(\$V18,\$W18,\$X18,\$Y18,\$Z18,\$AB18,\$AC18,\$AD18,\$AO18 ,\$AZ18)))),IF(LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UPPER(\$R\$2),"NA",""),"FAIL",""),"PASS",""),4)="F FFFFFFFFFFFFFFFFF","FAIL","PASS"),"FAIL *"))

The leaving the cell blank part of the formula works however it allows the remainder of the formula to only work if “fail” appears in the first cell it reads (in this case V18). If the “fail” appears in any of the other critical cells, it does not work at all.

Also as a side project not sure what the substituting to \$R\$2 does so if anyone knows how to clean this up, let me know.

## Formula To Make Cell Blank Instead Of Zero

Oct 29, 2009

I am looking for a formula that will work with my current formula, and check that cells a1 and b1 contains information. If they do contain info then the original formula should carry on as usual and leave the answer in cell c1. I also need it so when no information has been entered in cells A1 and B1, C1 will be blank instead of containing a zero.

This is the formula I have at the moment:
=IF(SUM(A1=0,B1>0),B1-A1,"No Charge?")

A B C
10.1810.82

## Make Cell Apear Blank

Jan 15, 2009

I have 2 worksheets, i have one sheet that has a form with lists, when nothing is selected the cells are blank. On the other sheet I have a few cells which = some of the sheets on the other worksheet. when nothing is selected, the cell displays 0 even though the cell its supposed to be displaying is blank.

## Make A Formula Output A Blank Cell?

Mar 20, 2009

I want my formula to output a blank cell if the answer is 0. Ex. [B1=IF(A1=0, ???, A1)]. I want B1 = A1 if A1 is not 0. I want B1 to output a blank cell if A1 = 0.

## Iserror: Make The Cell Go Blank With N/A Is Returned

Feb 12, 2010

How do I put in iserror in to this to make the cell go blank with N/A is returned. Only ever done this on vlookups. =IF(I15<E8,"TOOLING REQUIRES CALIBRATION","")

## Make A Cell Display 0 Or Remain Blank Instead Of #N/A?

Aug 15, 2009

How can I make a cell display 0 or remain blank instead of #N/A?

I have several cells that are either VLOOKUP or just normal sum functions but they all display #N/A.

## Make Cell Blank If Nothing Is Written In Another Cell?

Oct 30, 2013

I want to make a cell blank if nothing is written in another cell. I have used this formula in C4: =IF(ISNUMBER(C3),IF(C3<180,C3+180,C3-180),"")

## Combined If Statements - Make The Second Character In The Blank Cell?

Mar 6, 2014

I have a spreadsheet that i want to create a part number that contains 4 parts. Ex 1rl9. The cell i want this to be in is blank. What formula do i use to make the second character in the blank cell = r?

## Condense Code To Make More Efficient And Run Until Blank Cell

Apr 10, 2014

Any way of shortening the attached code. The first part 'Sub Loop1()' works great but I can't figure out how to shorten the second part. As you can see the distance between columns is always consistent i.e. add 5 columns to find the next outcome to work out the next result. Ideally I wanted to somehow loop through the next 5 columns again and again until the cell is blank.

[Code] ......

## Drag The Entire Thing Down And Be Able To Make It So That It Is Hidden (the Cell Is Blank)

Oct 23, 2009

First, I can get the balance formula, and when I drag the square at the bottom right, I am able to drag the entire formula down...I want to do that. However, when I drag it down, the number keeps popping up. I was wondering if there is a way to be able to drag the entire thing down and be able to make it so that it is hidden (the cell is blank) unless the debit or credit cell in the corresponding row is filled. Also, if possible, I want to be able to drag it down to infinity, so it can go on forever, so that there is no need to always drag it down when I add more things in it. I am attaching what I have till now.

## Make All Blank Cell Have Dash Without Affecting Other Cells With Data?

Jul 20, 2013

section 100
section 200

100-1
200-1

I have a large spreadsheet with text, numbers and blank cells. Is there a code a can use to make all blank cell have a dash (-) without affecting the other cell with data.

## Make Cell Blank For Exceptions (calculating Blood Sugars)

Aug 14, 2007

I am calculating blood sugars for my daughter and putting them in a spreadsheet. The formula is simple:

Blood sugar - target blood sugar / 20 which yields the amount of insulin that she needs to take. I want this cell to be blank unless I enter a value in the cell above it.

Next, I take the value from that formula and add it to the amount of insulin that she takes for eating.

The value in the top formula can be 0 or less, but, if the value in the bottom one is less than 0, I want the cell to be blank.

## Macro To Make A Cell Background Blank If It Is Not Orange Or Dark Blue?

Apr 17, 2008

Does anyone know how to use a macro to make a cell background blank if it is not orange or dark blue?

## Leaving Blank Cells Blank In Dragging Formula Combining Different Formulas In One Cell?

Aug 2, 2014

I can't modify my formula to leave blank cells blank when dragging it down, Also, I've got two formulas that i need to combine. Please view the comments I've put in cells E4, F2,F3,H2 and I2 to understand clearly what am seeking. See the attached worksheet.

## IF Blank Or If Not Blank Function That Works With Adjacent Cell With Formula In It?

Aug 12, 2014

I have one column that contains an If statement formula and would like the next column to then work off of the first column (i.e. if that 1st column returns a value then then adjacent column uses that result).

What is happening now is that it is returning #value (because I guess technically the cell isn't blank?)

## IF Statement To Leave Cell Blank If Multiple Cells Are All Blank?

Mar 12, 2014

I am looking for an IF statement that would leave a balance cell blank if both the revenue and expense cells are blank, otherwise a formula would be calculated.

## How To Populate Blank Cells With Sequence Until Non Blank Cell Is Encountered

Mar 22, 2014

I presume this is fairly simple to do, since it's certainly easy enough to do manually by filling in a couple of rows and dragging them down, but I need it to be performed in a macro that I can run before other macros run.

What I need specifically is for the macro to go to G1 and insert the number .01... Then go to G2 and insert .02... Then G3 and insert .03... And repeat this until it finds the first non-blank cell ( row number this occurs at varies), at which point it ends and does nothing to that populated cell or any other cell in the column thereafter (including other blanks farther down).

This all needs to be done in Arial, 10pt, white.

## List - Filling In Each Blank Cells With Value Contained In First Non-blank Cell Above It

Feb 27, 2013

I have a list that looks something like this:

Column B

Row 4 Item 1
Row 5 Item 2
Row 6
Row 7
Row 8 Item 3
Row 9
Row 10 Item 4
Row 11
Row 12
Row 13
Row 14 Item 5

The range of cells in column B containing the items has a name "ColStreams"

I need to go through the list, filling in each blank cells with the value contained in the first non-blank cell above it - so, in this case, rows 6 and 7 would contain "Item 2", row 9 would contain "Item 3", rows 11-13 would contain "Item 4" and so on.

## Replace #VALUE! Error For Blank Cells With Blank Cell

Nov 17, 2008

The formula below calculates appropriately, however, if any of the cells (E12,E14, E21, E22, E28, E29) are blank, it returns a #VALUE! error. I would like the cell to remain blank. How can I do this? The formula is listed below.

=(SUM(E34-E6)-(SUM((E12)+E14)-(SUM((E21)+E22)-(SUM(E28)+E29))))

## Making A Cell Blank Referring To Another Blank Cell?

May 8, 2014

Im currently writing a payroll sheet within excell and trying to write an IF statement to make a cell blank if referring to another blank cell but it is showing the formula is incorrect. Below is the following IF statement that im using;

=IF( F4 <97, AM4*0.8, IF( F4 >=97, AM4*1.1, IF( F4=" ";" "; AM4)))

## Keep Cell Blank If Referencing Cell Within IF Formula Is Blank

Jul 28, 2014

My workbook is for financial planning but I'm attempting to streamline an input page (name, birthdate, etc) that will be referenced throughout the entire workbook to trigger automatic calculations (present value, education calculations, etc).

The cell in the input page is a birthdate - which when populated will trigger a cell on a different worksheet to calculate the respective age using this formula:

Code:
=IF(MONTH(TODAY())>MONTH('Input Page'!B30),YEAR(TODAY())-YEAR('Input Page'!B30), IF(AND(MONTH(TODAY())=MONTH('Input Page'!B30),DAY(TODAY())>=DAY('Input Page'!B30)),
YEAR(TODAY())-YEAR('Input Page'!B30),(YEAR(TODAY())-YEAR('Input Page'!B30))-1))

The problem is if there is nothing written in the birthdate cell then the age cell will automatically calculate 114 (reference photo below). Ideally I'd like that cell to be blank if nothing is in the birthdate cell on the input worksheet. I'm assuming since I'm using an IF formula to calculate the age already then I'll need to use a macro to to an "ignore".

[URL] ...........

## Insert Blank Row If Adjacent Cell Value Is Blank

Jan 7, 2013

If the value of the adjacent cell in column A is blank, insert a blank row through Column B:J.

## Return Blank If Concatenating With Blank Cell?

Apr 3, 2014

in one column of my spreadsheet and it is returning the correct concatenation for the appropriate lines. However, I wish to have the column's cells return an answer of blank (" ") if B15, B16... etc is blank. In other words, at the moment, a correct answer would read something like '1810sd0000' C10 and B15 used, while an incorrect answer would still display '1810', but I want it to be a blank cell.

## Copy Or Create 'blank Cell' As 'blank'

Feb 4, 2009

using a formula to copy a cell A1. if A1 is blank, i need forumula result in blank instead 0...is it possible..

## First Blank Cell In Column & Offset To 1st Blank In Row

Jul 11, 2007

I have checked archives, some similiar but not quite what I want.

In code below I want the output instead of going offset one column to right in same row to go one column to right into the next blank cell.

## Set Date In Table Cell To Be Date In Another Cell Plus 30 But Leave Blank If Other Cell Is Blank

Nov 19, 2013

I have made a table which contains 2 date columns, Both formatted as date (dd-mmm-yy), the second column is calculated as the first column, + 30, The dates work out fine when adding to a date in the first columns, but from a blank cell it displays 30-Jan-00.

e.g
Started
Finishes

12-Nov-13
12-Dec-13

30-Jan-00

09-Nov-13
09-Dec-13

11-Nov-13
11-Dec-13

Rather than delete the rows with the blanks in the Started column, is there a formula that I can use so that the cells in the "Finishes" column is left blank when the "Started" cells are blank?

The current formula for cells in the "Finished" column is:

=[@Started]+30

## Blank Cell If C3 Is Blank

Feb 17, 2014

I'm using this formula

=IF(AND(\$C\$54="C",C3="C"),"C1",IF(C3=\$C\$54,1,0))

Where C3 compares with C54, I want to have a blank cell if C3 is blank.

## N/A# Make Blank

Nov 17, 2008

#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A

=RtHistory("IDN",B5,B7:D7,B6,"LAY:HOR NULL:SKIP ZERO:SKIP SORT:ASC")

the #N/A errors are based on the line above. Is there a way to remove the #N/A? I want to make Row B/C/D above blank

## Make Cells Appear Blank When Not In Use?

May 16, 2014

I have column g as a dollar amount, and a running total in column h, where g4+h3=h4. I want the cells in h to appear blank until there is a dollar amount entered into the corresponding g cell.