cell value based on null/not null in another cell

's Computer Specifications

I would like to write a formula in cell C23 so that this cell will display as
empty if cell A23 is empty (null) but will pull the value from cell A1 if A23
has a value entered into it. I have spent some time working in Access but my
knowledge of Excel sytax is limited.

Thanks in advance

's Computer Specifications

Assuming that the condition on A23 really is empty (and not, for instance, a
formula whose result is a null string): =if(isblank(a23),"",a1)

"spence" wrote:

> I would like to write a formula in cell C23 so that this cell will display as
> empty if cell A23 is empty (null) but will pull the value from cell A1 if A23
> has a value entered into it. I have spent some time working in Access but my
> knowledge of Excel sytax is limited.
>
> Thanks in advance

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: If cell is not null, add value to adjecent cell	Jacob Skaria	Microsoft Excel Programming	0	14th Apr 2009 06:12 PM
Copy contents of Cell to array based on Col1 value not null	missleigh	Microsoft Excel Programming	0	12th Apr 2006 10:13 PM
cell shows 0 when referenced cell is null	=?Utf-8?B?ZGVl?=	Microsoft Excel Worksheet Functions	8	6th Oct 2005 01:39 PM
if cell has null value, move data from one cell to another	looped	Microsoft Excel Programming	1	17th May 2005 12:48 AM
If a cell is not null, insert a formula into another cell	Michelle Hillard	Microsoft Excel Worksheet Functions	3	24th Dec 2003 10:53 PM