If a cell=((ISBLANK(REF)), then (Another NOT(ISBLANK(cell)))?

[ocp_zoe]

Hi, I'm trying to set a formula so that if a cell is blank and the cell above is not, then the destination cell takes the value of the not blank cell:

(in this example C2 is the value having cell and C3 is the blank cell)

Something like =if((ISBLANK(C3)), AND(NOT(ISBLANK(C2))),THEN C2)

Your help would be greatly appreciated.

 

[Jonmo1]

Welcome to the board.

What type of data is in the cells, Text Or Number?
What if BOTH cells have a Value?
What if NEITHER cell has a value?

Assuming you want the bottom cell (C3) if BOTH have a value

If it's Text, try

=LOOKUP(REPT("z".255),C2:C3)

If it's Number, try

=LOOKUP(9.99999999999999E+307,C2:C3)

Hope that helps


These will both return errors if both cells are blank.

 

[ocp_zoe]

Hi and thanks for the reply.
In this instance the cell with a value will have text, the other will have nothing entered.
Example:
C2=Corporate Bonds
C3=totally blank
And I'd like cell D3 to have the text in C2.

This will be replicated down the sheet as I know there is a blank after every desired value.

 

[ocp_zoe]

For your other questions, this formula will only be entered in cells next to the blank cell, so there will never be a case where both cells have values nor both do not.

 

[Jonmo1]

Are you trying to fill the blanks in column C with the value from above?

 

[ocp_zoe]

No, I'm trying to copy the text from the non blank cell into another column.
In my worksheet there will always be a blank cell below the desired cell in column C. At certain points I need to take the value of C2 and put it in column D.

 

[Jonmo1]

I guess you just want

=IF(C3="",C2,"")

 

[mikerickson]

If only one has a value in it =C2&C3 would work.

 

[ocp_zoe]

Sample Data
C1. CORPORATE BONDS
C2. CORPORATE BONDS
C3. BLANK
C4. EUROPEAN BONDS
C5. EUROPEAN BONDS
C6. BLANK


Goal is to have
D3=CORPORATE BONDS
And
D6=EUROPEAN BONDS
Etc. Down the sheet.

 

[ocp_zoe]

I'm trying for a formula that says "if the referenced cell is blank and the cell above it is not blank, take the value of the not blank cell and put it here".