Formula Showing Zero instead of nothing
 

Hi. I have a very simple formula.

=IF($J656<"",G655,CodeDisplay(MID($A$1,8,1),$B656 ,$B657))

It finds out if its row has been writen on (Col J must have a value if its
writen on). If so it will copy what information it has above it. If it is
empty it will use my CodeDisplay function to find out if it should display a
blank (it does this if its on a blank row and is inbetween two filled rows)
or display a Dash (Based on if I have A1 say so.

Anyway, on my spreadsheet I have several entries from many different
folders. All the entries from the same folder are bunched together and each
folder is seperated by a blank row. All the formulas on Blank rows show up
as a blank (as they should). The formulas that are on filled rows copy the
value above them (as they should). The problem I have is that if a series of
rows from the same folder have no top entry they turn up as Zeros. They
should just turn up as Blanks by Copying the row above them. They've done
this the past few months I've had them. All of a sudden they are turning up
as zeros. Did I change some option unintentially?! How can I return them
back to showing up as blanks?

Thank you for your help. Sorry for the long post which could easily be just
a few lines. I just like to be as specific as I can.

Abode

Formula Showing Zero instead of nothing
 

Check
Tools | Options
and on the [View] tab, make sure the checkbox next to 'Zero Values' is
cleared.

"Abode" wrote:

Hi. I have a very simple formula.

=IF($J656<"",G655,CodeDisplay(MID($A$1,8,1),$B656 ,$B657))

It finds out if its row has been writen on (Col J must have a value if its
writen on). If so it will copy what information it has above it. If it is
empty it will use my CodeDisplay function to find out if it should display a
blank (it does this if its on a blank row and is inbetween two filled rows)
or display a Dash (Based on if I have A1 say so.

Anyway, on my spreadsheet I have several entries from many different
folders. All the entries from the same folder are bunched together and each
folder is seperated by a blank row. All the formulas on Blank rows show up
as a blank (as they should). The formulas that are on filled rows copy the
value above them (as they should). The problem I have is that if a series of
rows from the same folder have no top entry they turn up as Zeros. They
should just turn up as Blanks by Copying the row above them. They've done
this the past few months I've had them. All of a sudden they are turning up
as zeros. Did I change some option unintentially?! How can I return them
back to showing up as blanks?

Thank you for your help. Sorry for the long post which could easily be just
a few lines. I just like to be as specific as I can.

Abode

Formula Showing Zero instead of nothing
 

Awesome. Thanks. I don't quite know how that got Checked in the first place.
Maybe I clicked it by mistake while searching through options to help
another person.

"JLatham" wrote:

Check
Tools | Options
and on the [View] tab, make sure the checkbox next to 'Zero Values' is
cleared.

"Abode" wrote:

Hi. I have a very simple formula.

=IF($J656<"",G655,CodeDisplay(MID($A$1,8,1),$B656 ,$B657))

It finds out if its row has been writen on (Col J must have a value if its
writen on). If so it will copy what information it has above it. If it is
empty it will use my CodeDisplay function to find out if it should display a
blank (it does this if its on a blank row and is inbetween two filled rows)
or display a Dash (Based on if I have A1 say so.

Anyway, on my spreadsheet I have several entries from many different
folders. All the entries from the same folder are bunched together and each
folder is seperated by a blank row. All the formulas on Blank rows show up
as a blank (as they should). The formulas that are on filled rows copy the
value above them (as they should). The problem I have is that if a series of
rows from the same folder have no top entry they turn up as Zeros. They
should just turn up as Blanks by Copying the row above them. They've done
this the past few months I've had them. All of a sudden they are turning up
as zeros. Did I change some option unintentially?! How can I return them
back to showing up as blanks?

Thank you for your help. Sorry for the long post which could easily be just
a few lines. I just like to be as specific as I can.

Abode

Formula Showing Zero instead of nothing
 

That kind of thing happens more often than you might think - and often leaves
us scratching our heads.

"Abode" wrote:

Awesome. Thanks. I don't quite know how that got Checked in the first place.
Maybe I clicked it by mistake while searching through options to help
another person.

"JLatham" wrote:

Check
Tools | Options
and on the [View] tab, make sure the checkbox next to 'Zero Values' is
cleared.

"Abode" wrote:

Hi. I have a very simple formula.

=IF($J656<"",G655,CodeDisplay(MID($A$1,8,1),$B656 ,$B657))

It finds out if its row has been writen on (Col J must have a value if its
writen on). If so it will copy what information it has above it. If it is
empty it will use my CodeDisplay function to find out if it should display a
blank (it does this if its on a blank row and is inbetween two filled rows)
or display a Dash (Based on if I have A1 say so.

Anyway, on my spreadsheet I have several entries from many different
folders. All the entries from the same folder are bunched together and each
folder is seperated by a blank row. All the formulas on Blank rows show up
as a blank (as they should). The formulas that are on filled rows copy the
value above them (as they should). The problem I have is that if a series of
rows from the same folder have no top entry they turn up as Zeros. They
should just turn up as Blanks by Copying the row above them. They've done
this the past few months I've had them. All of a sudden they are turning up
as zeros. Did I change some option unintentially?! How can I return them
back to showing up as blanks?

Thank you for your help. Sorry for the long post which could easily be just
a few lines. I just like to be as specific as I can.

Abode