Logical Functions

Copper 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
If you want to return either of 2 values, then the formula is:
=IF(S4>0.5,
T4,
D4*0.085)