Logical Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-359191%22%20slang%3D%22en-US%22%3ELogical%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359191%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-359191%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359286%22%20slang%3D%22en-US%22%3ERe%3A%20Logical%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359286%22%20slang%3D%22en-US%22%3EIf%20you%20want%20to%20return%20either%20of%202%20values%2C%20then%20the%20formula%20is%3A%3CBR%20%2F%3E%3DIF(S4%26gt%3B0.5%2C%3CBR%20%2F%3ET4%2C%3CBR%20%2F%3ED4*0.085)%3C%2FLINGO-BODY%3E
Highlighted
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?

1 Reply
Highlighted
If you want to return either of 2 values, then the formula is:
=IF(S4>0.5,
T4,
D4*0.085)