Logical Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-359192%22%20slang%3D%22en-US%22%3ELogical%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359192%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20IF%2FLogical%20Functions%20in%20Excel%2C%20I%20am%20unable%20to%20create%20an%20%22if%22%20statement%20referencing%20a%20formula.%20For%20instance%2C%20I%20want%20a%20cell%20to%20populate%20an%20answer%20to%20a%20formula%20based%20off%20of%20whether%20or%20not%20another%20cell%20is%20above%20a%20certain%20value.%20It%20is%20not%20allowing%20me%20to%20do%20this%2C%20and%20I%20cannot%20find%20the%20solution%20to%20this%20problem.%20My%20best%20attempt%20was%20SUMIF(S4%26gt%3B.5%2C%22T4(D4*.085))...Help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELogical%20Formulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

When using IF/Logical Functions in Excel, I am unable to create an "if" statement referencing a formula. For instance, I want a cell to populate an answer to a formula based off of whether or not another cell is above a certain value. It is not allowing me to do this, and I cannot find the solution to this problem. My best attempt was SUMIF(S4>.5,"T4(D4*.085))...Help?

0 Replies