Stop INDIRECT function returning a 0 if cell is blank?

[Belinea2010]

Hi all

I'm new to the board so forgive me if I mess up.

I have a very basic INDIRECT function that is pulling data from a different page within the same workbook.

Please Login or Register  to view this content.

As you can see its referencing cell A1 of the Costs page.

The problem I'm having is if Cell A1 is blank (no data typed into it) then the function is return a 0 in the cell that the function is typed in.

I need it to keep the cell blank if no data exists in cell A1 of the Costs page.

I have been bashing my head on the screen all evening and cannot seem to understand how to make this work (can't see the wood for the tree's) so I'm hoping some of you kind people may be able to tell me where I am going wrong.

Thanks in advance

Bel

[samba_ravi]

=IF(ISBLANK(INDIRECT("Costs!A1")),"",INDIRECT("Costs!A1"))
try this

[FDibbins]

Hi, welcome to the forum

Unless there is more to your formula that you have mentions, then Im not sure why you would need to use INDIRECT() here...

=INDIRECT("Costs!A1")

.
If you are simply referencing cell A1 on sheet Cost, then you could simplify that to...
=cost!A1

Or, rather...
=IF(cost!A1="","",cost!A1)

[Belinea2010]

nflsales, thanks for the reply and your suggestion.

It was perfect and did exactly what I wanted,

Thanks again.

[Belinea2010]

Hi FDibbins

Thanks for the reply and suggestion.

No my formula is exactly as stated but as I said in my original post the formula is pulling data from a different page within the same workbook.

If a user drags the contents of one cell to replace another, or just cuts and pastes from one cell into another the formulas get confused and display #REF.

By making them INDIRECT, this over comes this unwanted behavior from Excel..

Thanks again.

[Cardio_Excel]

I have this exact same problem and I followed the suggestion of FDibbins but it did not work. Could I ask what solution did you achieve here?? I see that nflsales reply is missing as well. Thanks in advance!

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread