PC Review


Reply
Thread Tools Rate Thread

cell reference question

 
 
bfont
Guest
Posts: n/a
 
      24th Feb 2009
how do i write a function that basically says "if there's anything in cell
xx, return the data from that cell. if there is nothing in cell xx, leave the
cell blank".
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      24th Feb 2009
try

=IF(A1<>"",A1,"")

Mike

"bfont" wrote:

> how do i write a function that basically says "if there's anything in cell
> xx, return the data from that cell. if there is nothing in cell xx, leave the
> cell blank".

 
Reply With Quote
 
Shane Devenshire
Guest
Posts: n/a
 
      24th Feb 2009
Hi,

You can use

=IF(A1="","",A1)

or if the only things in A1 are numbers or formulas that return numbers:

=IF(A1,A1,"")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"bfont" wrote:

> how do i write a function that basically says "if there's anything in cell
> xx, return the data from that cell. if there is nothing in cell xx, leave the
> cell blank".

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell reference question blumonkey Microsoft Excel Worksheet Functions 4 19th May 2008 09:17 PM
Cell Reference Question JMK Microsoft Excel Misc 3 13th Jan 2008 08:44 PM
Cell Reference Question =?Utf-8?B?QmlnIERvZw==?= Microsoft Excel Misc 3 14th Aug 2007 03:17 PM
Cell Reference question Tom Microsoft Excel Misc 1 21st Sep 2004 01:56 AM
Re: Cell Reference Question Frank Kabel Microsoft Excel Misc 0 27th Feb 2004 04:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:55 AM.