SOLVED

IF ?

%3CLINGO-SUB%20id%3D%22lingo-sub-2905743%22%20slang%3D%22en-US%22%3EIF%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905743%22%20slang%3D%22en-US%22%3E%3CP%3EWhat's%20wrong%20with%20this%20formula%3F%3C%2FP%3E%3CP%3E%3DIF(U5%26gt%3B%3D200%2C%22DATA!J4*SCORECARD!U5%22%2CIF(U5%26gt%3B%3D400%2C%22DATA!J16*SCORECARD!U5%22%2CIF(U5%26gt%3B%3D600%2C%22DATA!J28*SCORECARD!U5%22)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20three%20teirs.%20I%20want%20the%20formula%20to%20look%20at%20one%20cell%2C%20determine%20what%20tier%20requires%20to%20answer%2C%20and%20deleiver%20a%20%22this%20times%20that%22%20answer.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2905743%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2905768%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2905768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491902%22%20target%3D%22_blank%22%3E%40DaCrab_101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(U5%26gt%3B%3D600%2C%22DATA!J28*SCORECARD!U5%22%2CIF(U5%26gt%3B%3D400%2C%22DATA!J16*SCORECARD!U5%22%2CIF(U5%26gt%3B%3D200%2C%22DATA!J4*SCORECARD!U5%22)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20want%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2906174%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2906174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F491902%22%20target%3D%22_blank%22%3E%40DaCrab_101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIFNA(LOOKUP(U5%2C%20%7B200%2C400%2C600%7D%2C%20%7BDATA!J4%2CDATA!J16%2CDATA!J28%7D%20)*SCORECARD!U5%2C%20%22nothing%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2908752%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2908752%22%20slang%3D%22en-US%22%3EThanks!%3C%2FLINGO-BODY%3E
Occasional Contributor

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. 

4 Replies

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

best response confirmed by DaCrab_101 (Occasional Contributor)
Solution

@DaCrab_101 

As variant

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