Forum Discussion
X-Voxel
Mar 01, 2019Copper Contributor
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 ano...
Twifoo
Mar 01, 2019Silver Contributor
If you want to return either of 2 values, then the formula is:
=IF(S4>0.5,
T4,
D4*0.085)
=IF(S4>0.5,
T4,
D4*0.085)