Home

Logical Functions

X-Voxel
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
If you want to return either of 2 values, then the formula is:
=IF(S4>0.5,
T4,
D4*0.085)
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies