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
Highlighted
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
Highlighted

@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 ?

Highlighted
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.
Highlighted

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
Excel If Functions
Mfouad2255 in Excel on
10 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
2 lists, 1 if
Bartosz Heller in Excel on
4 Replies