Need Help


B

Bob

Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob
 
Ad

Advertisements

P

pmartglass

since you don't want to put something in cell B1, would you consider having
one page be your input and another page be what you want?



Eduardo said:
Hi,
in B1 enter

=IF(c1="CLOSED",a1)

Bob said:
Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob
 
J

JLatham

Bob, if you are the same 'Bob' that was asking about setting up a workbook to
track account ranking based on months in/amount of arrears:
Bob, I have actually put together a couple of workbooks that I think pretty
much do what you are looking for based on your description of needs. If
you'd like to get them to examine, just contact me at (remove spaces)
Help From @ JLatham Site.com

In either case, pardon the interruption of this specific discussion.
Although I do agree with your assessment in another thread with same question
that a VBA solution is probably the way to go.
 
Ad

Advertisements

D

Dave Peterson

Check your other post.
Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells:
a1 [format m/d/yyyy h:mm] - contents= 1/1/2010
b1 [format m/d/yyyy h:mm] - contents= null
c1 [format text] - contents "CLOSED"
All column & cell values are loaded in from a csv file. I can't [i.e. don't
want to] place a formula in cell b1 'cause I'll lose it on the next import,
so I'm trying to place a formula in a 4th cell [d1] that will a) see if c1
contains a value of "CLOSED", and b) if true, copy the date/time from a1
into b1. I've tried variations using IF and EXACT formulae & had no
success; e.g.
=IF(c1="CLOSED",b1=a1
=IF(c1="CLOSED",((VALUE(b1=a1))
Any suggestions on howto get it done? thanks!!!! - bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top