Need Help
in [Functions]
|
From: Bob on 30 Mar 2010 13:30 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
From: Eduardo on 30 Mar 2010 13:36 Hi, in B1 enter =IF(c1="CLOSED",a1) "Bob" wrote: > 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
From: pmartglass on 30 Mar 2010 13:40 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" wrote: > Hi, > in B1 enter > > =IF(c1="CLOSED",a1) > > "Bob" wrote: > > > 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
From: JLatham on 30 Mar 2010 15:15 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. "Bob" wrote: > 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
From: Dave Peterson on 30 Mar 2010 15:57 Check your other post. Bob wrote: > > 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 -- Dave Peterson
|
Pages: 1 Prev: Protected Sheets Next: Countif function to show how often numbers within a range are pres |