Sorting Data
 

My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there
is a value in column d. When attempting to sort the results from shortest to
longest number of days, I lose the formula results due to a Ref error. How
can I correct this problem?

thanks,
harley

Sorting Data
 

Probably a typeo...........

a2 should be a5

=If(d5=0,0,a5-i5)

Vaya con Dios,
Chuck, CABGx3


"Harley" wrote:

My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there
is a value in column d. When attempting to sort the results from shortest to
longest number of days, I lose the formula results due to a Ref error. How
can I correct this problem?

thanks,
harley

Sorting Data
 

if a2 is something like today's date, make it $a$2 so it doesn't move when
you sort.

"Harley" wrote:

My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there
is a value in column d. When attempting to sort the results from shortest to
longest number of days, I lose the formula results due to a Ref error. How
can I correct this problem?

thanks,
harley

Sorting Data
 

That got it!

thanks.

"dlw" wrote:

if a2 is something like today's date, make it $a$2 so it doesn't move when
you sort.

"Harley" wrote:

My formula =If(d5=0,0,a2-i5) generates number of days in inventory if there
is a value in column d. When attempting to sort the results from shortest to
longest number of days, I lose the formula results due to a Ref error. How
can I correct this problem?

thanks,
harley