Sorting Data

[Harley]

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

 

[CLR]

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

a2 should be a5

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

Vaya con Dios,
Chuck, CABGx3

 

[dlw]

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

 

[Harley]

That got it!

thanks.

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