If blank

coastguard

New Member
Joined
Sep 30, 2006
Messages
6
Can you have a formula that if a cell is blank it will copy a value from another cell

i.e. if C:4 has no date copy A:4 to A:100
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

coastguard

New Member
Joined
Sep 30, 2006
Messages
6
sorry im not very good at explaining things

I have a number in A:4 which I want copied to another cell i.e. A:100 if C:4 is blank or preferably If C:4 has a date i.e. 04/10/06
 

coastguard

New Member
Joined
Sep 30, 2006
Messages
6

ADVERTISEMENT

In cell A100:

=if(isblank(C4),A4,"'))

great im starting to understand it but what i realy need is if it is not blank does that make sence?
 

JohnnyTightlips

Board Regular
Joined
Aug 13, 2006
Messages
94
Sorry mate, not entirely sure what you're after.

If you change the "" in the formula I wrote to C4 it will mean:

if cell C4 is blank, copy the value in A4 into cell A100, otherwise (i.e. cell C4 is NOT blank) copy C4's value into cell A100
 

coastguard

New Member
Joined
Sep 30, 2006
Messages
6

ADVERTISEMENT

Sorry what i am trying to do is if cell C4 is NOT blank copy A4 value into cell A100

cheers and thanks for the patience
 

JohnnyTightlips

Board Regular
Joined
Aug 13, 2006
Messages
94
in that case, in cell A100:

=if(not(isblank(C4)),A4,"'))

you can change the "' to something else if you like
 

Watch MrExcel Video

Forum statistics

Threads
1,114,090
Messages
5,545,897
Members
410,711
Latest member
Josh324
Top