Forum Discussion

X-Voxel's avatar
X-Voxel
Copper Contributor
Mar 01, 2019

Logical Functions

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?

Excel
  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 02, 2019
    If you want to return either of 2 values, then the formula is:
    =IF(S4>0.5,
    T4,
    D4*0.085)

Resources