SOLVED

New Contributor

# Problem with ranking

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 Replies
best response confirmed by CK_147 (New Contributor)
Solution

# Re: Problem with ranking

Try this:

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

# Re: Problem with ranking

That was the solution thank you so much Hans

Greetz Corne