Forum Discussion
=If equasions
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 ...
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.
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.