#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default IF... do nothing

How do you get an if statement to do nothing?

I have 2 spreadsheets that get updated monthly. one is overwritten, and I
then want the new data to automatically insert into the column for the
corresponding month in the other sheet.

=IF([Asset Allocation.xls]Asset Allocation'!$C$5=$Z$2,[Asset
Allocation.xls]Asset Allocation'!D8,0)

So if C5 in the other sheet is the same as z2 in this sheet, put in the data
from D8 into this cell.

Problem is, when you move to the next month, the statement is no longer
true, so it inserts a 0 or blank string. How do I get it to do nothing??
(thereby leaving the existing data)

Is there an easier way of doing this??

Thank you
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default IF... do nothing

You can't with a formula, if will either have a formula, and hence show its
result, or it will have a value.


--
__________________________________
HTH

Bob

"vdg_wdebroe" wrote in message
...
How do you get an if statement to do nothing?

I have 2 spreadsheets that get updated monthly. one is overwritten, and I
then want the new data to automatically insert into the column for the
corresponding month in the other sheet.

=IF([Asset Allocation.xls]Asset Allocation'!$C$5=$Z$2,[Asset
Allocation.xls]Asset Allocation'!D8,0)

So if C5 in the other sheet is the same as z2 in this sheet, put in the
data
from D8 into this cell.

Problem is, when you move to the next month, the statement is no longer
true, so it inserts a 0 or blank string. How do I get it to do nothing??
(thereby leaving the existing data)

Is there an easier way of doing this??

Thank you



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default IF... do nothing

Oh bum. That would explain why I have had no luck for 2 days!

In that case, is there any way for me to get excel to insert a new column of
data every time the master sheet is updated?

"Bob Phillips" wrote:

You can't with a formula, if will either have a formula, and hence show its
result, or it will have a value.


--
__________________________________
HTH

Bob

"vdg_wdebroe" wrote in message
...
How do you get an if statement to do nothing?

I have 2 spreadsheets that get updated monthly. one is overwritten, and I
then want the new data to automatically insert into the column for the
corresponding month in the other sheet.

=IF([Asset Allocation.xls]Asset Allocation'!$C$5=$Z$2,[Asset
Allocation.xls]Asset Allocation'!D8,0)

So if C5 in the other sheet is the same as z2 in this sheet, put in the
data
from D8 into this cell.

Problem is, when you move to the next month, the statement is no longer
true, so it inserts a 0 or blank string. How do I get it to do nothing??
(thereby leaving the existing data)

Is there an easier way of doing this??

Thank you




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



All times are GMT +1. The time now is 04:14 AM.

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"