Cell referencing error, need help. Thank you

[pedie]

a1 = datas!a7

when sheet datas, a7 has no value it show 0.

can we eliminate this and show nothing when sheet datas, a7 has no value???


Thanks again!

 

[Trebor76]

Hi pedie,

Yes, there are two ways I can think of.

Firstly, you could use this formula:

=IF(LEN(data2!A7)=0,"",data2!A7)

Or, you can simply hide zeros. This may be preferable if you want to analyse the result in a formula. To do this, follow these three steps (Excel 2003 and prior):

1. From the Tools menu select Options
2. From the View tab, unclick the Zero values option
3. Click OK

Regards,

Robert

 

[pedie]

Robert, thank you so much that helps alot!!!!

keep helping people in need....Thanks again!

 

[Trebor76]

thank you so much that helps alot!!!!

You're welcome

keep helping people in need....Thanks again!

I'll try