CK_147Copper ContributorDec 01, 2021SolvedProblem with rankingSo 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. HansVogelaarDec 01, 2021CK_147 Try this: =ALS(D18<>"",5-D18,0)
2 RepliesReplies sorted by NewestHansVogelaarMVPDec 01, 2021CK_147 Try this: =ALS(D18<>"",5-D18,0)CK_147Copper Contributor to HansVogelaarDec 01, 2021That was the solution thank you so much HansGreetz Corne
CK_147Copper Contributor to HansVogelaarDec 01, 2021That was the solution thank you so much HansGreetz Corne