Posted to microsoft.public.excel.worksheet.functions

Shane Devenshire[_2_] Shane Devenshire[_2_] is offline

external usenet poster

Posts: 3,346

cell reference question

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell reference question	blumonkey	Excel Worksheet Functions	4	May 19th 08 09:17 PM
Cell Reference Question	JMK	Excel Discussion (Misc queries)	3	January 13th 08 08:44 PM
cell reference question	Island Girl	New Users to Excel	7	December 28th 07 02:20 AM
Cell Reference Question	Big Dog	Excel Discussion (Misc queries)	3	August 14th 07 03:17 PM
Cell Reference Question	tompal	Excel Worksheet Functions	2	January 12th 06 05:51 PM

All times are GMT +1. The time now is 04:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us