displaying zeros

[QuizToon]

HI all,

New to this site, heard good things so thought I would have a go.

I am using a vlookup to populate a worksheet (results) which getting the information from a different worksheet called stats. All is working fine with the exception of zero's

In the worksheet stats there are some entries that are zero's and other cells which are blank.

I want the results worksheet to display a zero when there is a zero entered. Currently it is showing blank whther the donor cell is blakn or a zero.

I need to be able to count the cell with a zero as an active number, this will hep in working out averages for example.

if there is 10 cells, 8 with a 10 and 2 zeros then the average will be 8x10/10, however if one of the zero's isnt a zero but blank then the resulting answer will be different. 8x10/9

I will be using a formula to count the number of cells that are active ie, 8 with a 10 in it and 1 with a zero.

Hope that makes sense

Many thanks

 

[Jonmo1]

There's not much you can do other than brute force testing if the vlookup 'doner cell' as you call it is blank. (I like that name for it).

=IF(VLOOKUP(...)="","",VLOOKUP(...))

 

[Jonmo1]

Then compound the issue with error handling..
=IFERROR(IF(VLOOKUP(...)="","",VLOOKUP(...)),"")

 

[Joe4]

New to this site, heard good things so thought I would have a go.

According to your profile, you joined in 2009 and have made 12 posts!

 

[QuizToon]

According to your profile, you joined in 2009 and have made 12 posts!

Very Helpful

Thank you