imported_jayhkr
New member
Ok, I need all MS Excel guru's! I'm working on a detailing specific project and have ample info, however I want to put this into a spreadsheet. What I have is a simple spreadsheet that looks like this:
Now what I want to do is change the "M" column. By doing so I need to change the "Difference" colums at "F, H, & J". As you can see column F has already added the "C" column which is fine however the "K" column has this formula: =SUM(F2,H2,J2). So what I need is "F, H, & J" column to show "0" until I post something in the "E, G, I" column's. So I was thinking of using the "IF" forumula. Like if "=IF(J16=0,0,"=sum(G16-I16") However that doesn't work. What I want is if there is nothing in cell J16 I want a "0" represented. However when I put the actual value of the weigh in, in cell J16 I want to have the formula to calculate properly the difference which would be =sum(G16-I16). This would then enter into colum "K" thus making the rest of the sheet proper. The only way at the moment this works is when all the cells are filled in and I want the % to initial weight to calculate as I go along as some days I will do more weigh-ins then other days. I hope this isn't to confusing, so any help is appreciated and I can explain better if questions arise. Thank you everyone.
Now what I want to do is change the "M" column. By doing so I need to change the "Difference" colums at "F, H, & J". As you can see column F has already added the "C" column which is fine however the "K" column has this formula: =SUM(F2,H2,J2). So what I need is "F, H, & J" column to show "0" until I post something in the "E, G, I" column's. So I was thinking of using the "IF" forumula. Like if "=IF(J16=0,0,"=sum(G16-I16") However that doesn't work. What I want is if there is nothing in cell J16 I want a "0" represented. However when I put the actual value of the weigh in, in cell J16 I want to have the formula to calculate properly the difference which would be =sum(G16-I16). This would then enter into colum "K" thus making the rest of the sheet proper. The only way at the moment this works is when all the cells are filled in and I want the % to initial weight to calculate as I go along as some days I will do more weigh-ins then other days. I hope this isn't to confusing, so any help is appreciated and I can explain better if questions arise. Thank you everyone.
