Problem with ranking

[CK_147]

So i can get around this. if no value in D18 it get 0 in F18, but if i fill in 0 in D18 the value in F18 stays 0 but must be 5. How can i fix this.

[#2 · Accepted solution]

@CK_147 

Try this:

=ALS(D18<>"",5-D18,0)

[#3]

That was the solution thank you so much Hans

Greetz Corne