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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies