Prev: Single Filter to change all Pivot Tables in a Workbook
Next: Using an Excel File in Mailings
From: Grumpy on 9 Apr 2010 22:45
Please Help. I have two cells, A1, B1. In B1 I want the current date if A1
is populated. If A1 is not populated I would like the message "< Input" in
B2.

Here is my formula in B1: =IF(A1="","< Input",TODAY())

It should be so simple, but I can't seem to make it work. Can anyone tell
me what is wrong?? Thanx for your help.
From: Teethless mama on 9 Apr 2010 23:13
I don't see anything wrong with the formula.
Make sure you set your calculation to Automatic.


"Grumpy" wrote:

> Please Help. I have two cells, A1, B1. In B1 I want the current date if A1
> is populated. If A1 is not populated I would like the message "< Input" in
> B2.
>
> Here is my formula in B1: =IF(A1="","< Input",TODAY())
>
> It should be so simple, but I can't seem to make it work. Can anyone tell
> me what is wrong?? Thanx for your help.
From: jim on 9 Apr 2010 23:14
in cell b1:

=IF(ISBLANK(A1),"< Input",TODAY())

format b1 to suit

Jim

"Grumpy" <Grumpy(a)discussions.microsoft.com> wrote in message
news:AEBC9B32-9586-4458-ACB3-F00FD885315B(a)microsoft.com...
> Please Help. I have two cells, A1, B1. In B1 I want the current date if
> A1
> is populated. If A1 is not populated I would like the message "< Input"
> in
> B2.
>
> Here is my formula in B1: =IF(A1="","< Input",TODAY())
>
> It should be so simple, but I can't seem to make it work. Can anyone tell
> me what is wrong?? Thanx for your help.

From: ozgrid.com on 9 Apr 2010 23:37
Your formulas works for me. Be aware though, ="" is NOT the same as A1 being
empty as a formula (in which case the cell is not empty) can return ""
(empty text). You MIGHT need;

=IF(ISBLANK(A1),"< Input",TODAY())



--
Regards
Dave Hawley
www.ozgrid.com
"Grumpy" <Grumpy(a)discussions.microsoft.com> wrote in message
news:AEBC9B32-9586-4458-ACB3-F00FD885315B(a)microsoft.com...
> Please Help. I have two cells, A1, B1. In B1 I want the current date if
> A1
> is populated. If A1 is not populated I would like the message "< Input"
> in
> B2.
>
> Here is my formula in B1: =IF(A1="","< Input",TODAY())
>
> It should be so simple, but I can't seem to make it work. Can anyone tell
> me what is wrong?? Thanx for your help.

From: Dave Peterson on 10 Apr 2010 08:24
Maybe you have a space character in A1.

You could select A1 and hit the delete key on the keyboard to clear the contents
of that cell.

Or you could change your formula:
=if(trim(a1)="","< Input",Today())

If this doesn't help, make sure that you have calculation turned to automatic.
In xl2003 menus, it's under:
Tools|Options|Calculation tab

===
Just an aside, if A1 has something in it, your formula will return the current
date -- each day it'll change.

If you want that date to be static, you'll need a different approach.

Take a look at JE McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html
for a macro approach.

Grumpy wrote:
>
> Please Help. I have two cells, A1, B1. In B1 I want the current date if A1
> is populated. If A1 is not populated I would like the message "< Input" in
> B2.
>
> Here is my formula in B1: =IF(A1="","< Input",TODAY())
>
> It should be so simple, but I can't seem to make it work. Can anyone tell
> me what is wrong?? Thanx for your help.

--

Dave Peterson
 | 
Pages: 1
Prev: Single Filter to change all Pivot Tables in a Workbook
Next: Using an Excel File in Mailings