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]

See post #7

 

[ocp_zoe]

This worked and was way easier than I thought it would be:
=IF(C3="",C2,"")

Thank you!

 

[Jonmo1]

Glad to help, thanks for the feedback.

Sometimes the simpler problems are harder to explain/understand..