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 o...
As variant
=IFNA(LOOKUP(U5, {200,400,600}, {DATA!J4,DATA!J16,DATA!J28} )*SCORECARD!U5, "nothing")
=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 !