|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 30th, 2005, 03:25 AM
|
|||
|
|||
Auto Populate a cell
If I enter "Electric" in cell d12 I want to have cell D14 auto populated
with "N/A" Can this be done - how? Thanks Hank 
|
|
#2
March 30th, 2005, 03:47 AM
|
|||
|
|||
|
Hank, here is one way, put this in D14, =IF(D12="Electric","N/A","")
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Bellsouth" wrote in message ... If I enter "Electric" in cell d12 I want to have cell D14 auto populated with "N/A" Can this be done - how? Thanks Hank
|
|
#3
March 30th, 2005, 01:14 PM
|
|||
|
|||
|
Paul,
Thanks for the answer. I failed to mention I'm using Excel 2000. You indicate you are using Excel 2002 & 2003. Could that be the reason I can't seem to get the formula to work? Hank "Paul B" wrote in message ... Hank, here is one way, put this in D14, =IF(D12="Electric","N/A","") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Bellsouth" wrote in message ... If I enter "Electric" in cell d12 I want to have cell D14 auto populated with "N/A" Can this be done - how? Thanks Hank
|
|
#4
March 30th, 2005, 02:27 PM
|
|||
|
|||
|
Paul,
Another thought - I have data validation in both cells. "Electric" is one of the choices in D12, "N/A" is one of the chocies in d14. Does that make a difference? Hank "Hank" wrote in message ... Paul, Thanks for the answer. I failed to mention I'm using Excel 2000. You indicate you are using Excel 2002 & 2003. Could that be the reason I can't seem to get the formula to work? Hank "Paul B" wrote in message ... Hank, here is one way, put this in D14, =IF(D12="Electric","N/A","") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Bellsouth" wrote in message ... If I enter "Electric" in cell d12 I want to have cell D14 auto populated with "N/A" Can this be done - how? Thanks Hank
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I use a look up list of names to auto populate address inf. | Dougen | Worksheet Functions | 5 | September 2nd, 2004 08:37 AM |
| Access Auto populate | Eric Cárdenas [MSFT] | Using Forms | 0 | June 7th, 2004 08:13 AM |
| Field Auto Populate | Glenn Heavens | Database Design | 5 | May 30th, 2004 07:37 PM |
| auto fill cell -2 Weeks from a static entered Date. | Jason Morin | Worksheet Functions | 1 | May 6th, 2004 10:43 PM |
| Do you have what it takes... | darno | Worksheet Functions | 0 | February 22nd, 2004 08:01 PM |
Linear Mode
