Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I set one cell to equal another if its contents are empty?

I have an insert for my work menu and everyday something changes on it. It
is a small square of information but I have duplicated it to print four on
the same page. I have assigned each cell to equal the original one so that
everytime I change the information in that cell it will automatically
duplicate it in the three other cells. My problem is that everytime I want
to clear a cell-the duplicate cells show a 0 and I want it to stay empty. If
I clear that cell the equal to function erases.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default How do I set one cell to equal another if its contents are empty?

"APElizondo" wrote
My problem is that everytime I want
to clear a cell-the duplicate cells show a 0 and I want it to stay empty.

If
I clear that cell the equal to function erases.


Is this what you're looking for?
=IF(ISBLANK(A1),"",A1))


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default How do I set one cell to equal another if its contents are empty?

Is this what you're looking for?
=IF(ISBLANK(A1),"",A1))


To expand on that; this formula should be put in the cells which are
duplicate cells. A1 refers to the original cell where you enter the
information.

Of course again, only if this is what you are looking for.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Selectively Clearing cell contents jdd Excel Worksheet Functions 2 April 22nd 06 04:06 AM
Function syntax to compare cell contents ES Excel Worksheet Functions 2 May 18th 05 03:53 PM
make cell contents equal to null value - not blank, but empty mpierre Excel Worksheet Functions 1 December 29th 04 06:57 AM


All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"