I have a formula that returns 0 instead of null. When I sort the column in
assending order the cells with 0 show up first. I need the cells to be null
so they do not show up first in the sort.

You can't have it both ways if the reason your formula returns zero instead
of blank is because you would get an error if you use "" instead of 0, if
not just change the formula that returns zero

--
Regards,

Peo Sjoblom

(No private emails please)


"dford" wrote in message
...
I have a formula that returns 0 instead of null. When I sort the column in
assending order the cells with 0 show up first. I need the cells to be
null
so they do not show up first in the sort.

Hi!

Try this:

=IF(your_formula=0,"",your_formula)

Biff

"dford" wrote in message
...
I have a formula that returns 0 instead of null. When I sort the column in
assending order the cells with 0 show up first. I need the cells to be
null
so they do not show up first in the sort.

What does your formula have.

Also check your tools, options, view, uncheck zero values
I just had to uncheck that myself, evidently it is a default.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dford" wrote in message ...
I have a formula that returns 0 instead of null. When I sort the column in
assending order the cells with 0 show up first. I need the cells to be null
so they do not show up first in the sort.

The formula reads =If(sheet1!B138=0."",sheet1!b138) This formula is in Sheet
2. The cell b138 in Sheet 1 is blank. When I sort the cells in Sheet 2 in
ascending order these cells appear first. I have unchecked zero values in
tools/options/view.

"David McRitchie" wrote:

What does your formula have.

Also check your tools, options, view, uncheck zero values
I just had to uncheck that myself, evidently it is a default.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dford" wrote in message ...
I have a formula that returns 0 instead of null. When I sort the column in
assending order the cells with 0 show up first. I need the cells to be null
so they do not show up first in the sort.

hopefully just a typo
=If(sheet1!B138=0."",sheet1!b138)
you have a period instead of a comma
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

And I would think that if B138 actually was a zero, then 0 should be returned:

=If(sheet1!B138="","",sheet1!b138)



David McRitchie wrote:

hopefully just a typo
=If(sheet1!B138=0."",sheet1!b138)
you have a period instead of a comma
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

--

Dave Peterson

okay it was strictly a typo, he did not paste the actual formula, because the
error constitutes a syntax error and is not accepted as a formula.