IF ?

[DaCrab_101]

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. 

[#2]

@DaCrab_101 

=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?

[#3 · Accepted solution]

@DaCrab_101 

As variant

=IFNA(LOOKUP(U5, {200,400,600}, {DATA!J4,DATA!J16,DATA!J28} )*SCORECARD!U5, "nothing")

[#4]

Thanks!

[#5]

Thanks !