Oct 31 2021 07:51 AM
What's wrong with this formula?
=IF(U5>=200,"DATA!J4*SCORECARD!U5",IF(U5>=400,"DATA!J16*SCORECARD!U5",IF(U5>=600,"DATA!J28*SCORECARD!U5")))
There are three teirs. I want the formula to look at one cell, determine what tier requires to answer, and deleiver a "this times that" answer.
Oct 31 2021 08:01 AM
=IF(U5>=600,"DATA!J28*SCORECARD!U5",IF(U5>=400,"DATA!J16*SCORECARD!U5",IF(U5>=200,"DATA!J4*SCORECARD!U5")))
Is this what you want?
Oct 31 2021 11:45 AM
SolutionAs variant
=IFNA(LOOKUP(U5, {200,400,600}, {DATA!J4,DATA!J16,DATA!J28} )*SCORECARD!U5, "nothing")
Oct 31 2021 11:45 AM
SolutionAs variant
=IFNA(LOOKUP(U5, {200,400,600}, {DATA!J4,DATA!J16,DATA!J28} )*SCORECARD!U5, "nothing")