Jul 08 2019 10:37 AM
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
Jul 08 2019 09:57 PM - edited Jul 09 2019 12:59 AM
Not sure if I have understood your requirement, but what are you trying to change with this worksheet ? why do you need IF function ?
Jul 09 2019 12:31 AM
Jul 09 2019 05:45 AM
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)