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