Home

=If equasions

%3CLINGO-SUB%20id%3D%22lingo-sub-743212%22%20slang%3D%22en-US%22%3E%3DIf%20equasions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743212%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20do%20an%20%3Dif%20formula%20but%20i'm%20not%20as%20proficient%20with%20those%20advanced%20formula's.%20pretty%20much%20i%20have%20a%20constant%20value%20that%20is%20going%20into%20an%20equation%20thats%20going%20into%20a%20weekly%20table.%20Right%20now%20i%20have%20that%20%3DSUM(E21%2B1163).%20example%20so%20when%20i%20input%20the%20hours%20my%20crew%20works%20it'll%20multiply%20hours%20by%20wages%20to%20get%20%3DE21%20and%20then%20add%20equipment%20cost%201163%20and%20give%20a%20total%20for%20the%20day%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-743212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744198%22%20slang%3D%22en-US%22%3ERe%3A%20%3DIf%20equasions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744198%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EWhat%20I%20have%20understood%20is%20that%20you%20are%20getting%20a%20result%20by%20using%20sum%20function%20which%20provide%20the%20total%20value%20for%20the%20day%20by%20summing%20up%20total%20wages%20and%20equipment%20costs.%3CBR%20%2F%3EThe%20'if'%20function%20is%20useful%20where%20you%20want%20to%20calculate%20the%20result%20based%20on%20a%20condition.%3CBR%20%2F%3EYou%20can%20write%20as%20follows%2C%3CBR%20%2F%3E%3Dif(condition%20eg.%20A1%3D1200%2Cvalue%20or%20formula%20if%20the%20condition%20is%20true%2Cvalue%20or%20formula%20if%20the%20condition%20is%20false)%3CBR%20%2F%3EExcel%20will%20give%20you%20the%20syntax%20once%20you%20enter%20%22%3Dif(%22.%3CBR%20%2F%3EI%20hope%20this%20will%20be%20helpful.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744055%22%20slang%3D%22en-US%22%3ERe%3A%20%3DIf%20equasions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744055%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372886%22%20target%3D%22_blank%22%3E%40YettieMonster%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20if%20I%20have%20understood%20your%20requirement%2C%20but%20what%20are%20you%20trying%20to%20change%20with%20this%20worksheet%20%3F%20why%20do%20you%20need%20IF%20function%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744760%22%20slang%3D%22en-US%22%3ERe%3A%20%3DIf%20equasions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744760%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20had%20figured%20it%20out%20last%20night%20with%26nbsp%3B%3DIF(E21%26gt%3B0%2C1163%2C0)%2BE21%26nbsp%3B%26nbsp%3B%3DIF(dailycost%26gt%3B0%2C1163%2C0)%2Bdaily%20cost.%3CBR%20%2F%3E%3CBR%20%2F%3Ebut%20now%20i'm%20trying%20to%20figure%20out%20how%20how%20to%20add%2Fmultiply%20equipment%20cost%20in%20another%20cell%20for%20how%20many%20day's%20worked.%20I%20tried%20the%20formula%20a%20few%20different%20ways%20but%20to%20no%20avail.%20So%20i%20had%20%22cheated%22%20by%20referencing%20the%20total%20costs%20minus%20daily%20to%20get%20my%20equipment%20costs%20per%20day%3C%2FP%3E%3CP%3E%3DSUM(G24-G21%2CI24-I21%2CK24-K21%2CM24-M21%2CO24-O21%2CQ24-Q21%2CE24-E21)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
YettieMonster
New Contributor

I'm trying to do an =if formula but i'm not as proficient with those advanced formula's. pretty much i have a constant value that is going into an equation thats going into a weekly table. Right now i have that =SUM(E21+1163). example so when i input the hours my crew works it'll multiply hours by wages to get =E21 and then add equipment cost 1163 and give a total for the day

3 Replies

@YettieMonster 

Not sure if I have understood your requirement, but what are you trying to change with this worksheet ? why do you need IF function ?

Hi,
What I have understood is that you are getting a result by using sum function which provide the total value for the day by summing up total wages and equipment costs.
The 'if' function is useful where you want to calculate the result based on a condition.
You can write as follows,
=if(condition eg. A1=1200,value or formula if the condition is true,value or formula if the condition is false)
Excel will give you the syntax once you enter "=if(".
I hope this will be helpful.

i had figured it out last night with =IF(E21>0,1163,0)+E21  =IF(dailycost>0,1163,0)+daily cost.

but now i'm trying to figure out how how to add/multiply equipment cost in another cell for how many day's worked. I tried the formula a few different ways but to no avail. So i had "cheated" by referencing the total costs minus daily to get my equipment costs per day

=SUM(G24-G21,I24-I21,K24-K21,M24-M21,O24-O21,Q24-Q21,E24-E21) 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 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
12 Replies