If Cell is Empty create rule to Display the current Date

**Sidewinder** · 09-05-2007, 12:54 PM

Im trying to find a formula that when a cell is empty ie this cell is linked to another cell on another worksheet and info has not been entered or is 0 then i want the cell to display the the current date ie =NOW()

Is this possible i have only beginners knowledge of excel so if anyone can help please make it as easy as possible to follow.

Thanks

Mark
Edit/Delete Message

**StephenR** · 09-05-2007, 01:00 PM

Like this?
=IF(OR(A1=0,A1=""),NOW(),"Whatever else you like")

**Ron Coderre** · 09-05-2007, 01:03 PM

You don't say what the other cell may contain or what you want to display if the other cell has a value.

See if this helps:

=IF(N(Sheet1!A1)>0,"a number is there",TODAY())

or maybe this:
=IF(Sheet1!A1>0,Sheet1!A1,TODAY())

Post back if you have more questions.

**Sidewinder** · 09-05-2007, 01:12 PM

Thanks for the quick response im well impressed.

Can you do me a massive favour and tell me the formula if the cell is currently reading:-
=+'Statement Log'!F5

Sorry but i have limited knowledge.

**Sidewinder** · 09-05-2007, 01:14 PM

I also need advise how to do the following also:-

Im trying to find a formula that when a cell is empty ie this cell is linked to another cell on another worksheet and info has not been entered then i want the cell to display the text AWAITING? Cell code at the moment is ='[Statement.xls]Statement Log'!$N$5 so wondered if you could give me the formula for this also?

Is this possible i have only beginners knowledge of excel so if anyone can help please make it as easy as possible to follow.

Thanks

Mark

**Ron Coderre** · 09-05-2007, 01:21 PM

Originally Posted by Sidewinder

Thanks for the quick response im well impressed.

Can you do me a massive favour and tell me the formula if the cell is currently reading:-
=+'Statement Log'!F5

Sorry but i have limited knowledge.

=IF(N('Statement Log'!F5)>0,"a number is there",TODAY())

or
=IF('Statement Log'!F5>0,'Statement Log'!F5,TODAY())

**Sidewinder** · 09-05-2007, 01:34 PM

Bingo! Unbelievable, really appreciate this it has helped me out more than you can imagine was going to pull my hair out, lol

Any chance you could work your magic with the following:-

Im trying to find a formula that when a cell is empty ie this cell is linked to another cell on another worksheet and info has not been entered then i want the cell to display the text AWAITING and not critical make the cell background red with white bold text. Cell code at the moment is ='[Statement.xls]Statement Log'!$N$5 so wondered if you could give me the formula for this also?

**Ikaabod** · 09-05-2007, 01:50 PM

If looking for a number greater than 0 this will work:
=IF('[Statement.xls]Statement Log'!$N$5<=0,"AWAITING",'[Statement.xls]Statement Log'!$N$5)

If looking to see if it is truly empty this will work:
=IF('[Statement.xls]Statement Log'!$N$5="","AWAITING",'[Statement.xls]Statement Log'!$N$5)

To change the format of the cell click on Format --> Conditional Formatting...
then for the condition 1:
Cell Value Is --> equal to --> ="AWAITING"
Then click on Format... and change it as you need.

**Sidewinder** · 09-05-2007, 01:58 PM

Thanks loads im not the best at this coding how would the formula go if the cell was linked to:-

='C:\Users\Public\Tapes\Shop Accounts\[2_FUNKY.xls]Stock Sheet'!$AF$4

**Ikaabod** · 09-05-2007, 03:02 PM

=IF('C:\Users\Public\Tapes\Shop Accounts\[2_FUNKY.xls]Stock Sheet'!$AF$4="","AWAITING",'C:\Users\Public\Tapes\Shop Accounts\[2_FUNKY.xls]Stock Sheet'!$AF$4)

I just replaced:
[Statement.xls]Statement Log'!$N$5
with:
C:\Users\Public\Tapes\Shop Accounts\[2_FUNKY.xls]Stock Sheet'!$AF$4