Forum Discussion
Solved
IF ?
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.
As variant
=IFNA(LOOKUP(U5, {200,400,600}, {DATA!J4,DATA!J16,DATA!J28} )*SCORECARD!U5, "nothing")
4 Replies
As variant
=IFNA(LOOKUP(U5, {200,400,600}, {DATA!J4,DATA!J16,DATA!J28} )*SCORECARD!U5, "nothing")- Thanks!
=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?
- Thanks !
