if then formula

[tindinh27]

Hello Friends,

I'm new here, so looking forward to learning and helping where I can!

Need to copy value from cell DC2 to O2 if O2 is blank...thank you in advance

[Special-K]

A cell cannot change the value of itself.
Can only be done in VBA.

Please Login or Register  to view this content.

[tindinh27]

thank you for your help!!!
Ok so now i know that a cell cannot change the value of itself, but how can I still write the formula on the spreadsheet if using a different cell like C2
i found several similar topics where other members advised using =IF(ISBLANK(B1),A1,B1) but it didn't work for me....

[Xandler]

First of all, why didn't it work? Is it returning an error? Not coming back with anything? It basically works like this. If B1 is blank, then return the value in A1, otherwise return the value in cell B1.

[FDibbins]

tindinh27 welcome to the forum

Agree that =IF(ISBLANK(B1),A1,B1) should work, what did you expect and what did you get?
I would write that as =IF(B1="",A1,B1)
But it it the exact same thing

[Special-K]

Put 1 in A1
In a blank cell type =IF(B1="",A1,B1)

If the cell doesnt say 1 then B1 is NOT blank, no matter what that it LOOKS like blank, it's not.