| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 124170 | 2012-04-10 21:35:00 | Excel formula help | rob_on_guitar (4196) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1269261 | 2012-04-10 21:35:00 | Hi guys, I am in need of a formula if possible for a spread sheet that will find the difference between 2 cells. In my set up I will be using cells C4 to C38 as the starting number and cells AB4 to AB38 as the finish number. The difference to be added into AC4 to AC38. This is a daily spread sheet. Cheers for any help. |
rob_on_guitar (4196) | ||
| 1269262 | 2012-04-10 21:49:00 | I must be misunderstanding the problem, coz the way I read it you just need the following formula in AC4: =C4-AB4 or if wanting absolute numbers only =abs(C4-AB4) Once the formula is entered simply drag the bottom right corner of the cell down to AC38 and they're all done. But am I missing a bigger factor? |
Paul.Cov (425) | ||
| 1269263 | 2012-04-10 21:56:00 | Thanks Paul, Ill give it a shot, basically the cells will be blank and data added throughout the day. | rob_on_guitar (4196) | ||
| 1269264 | 2012-04-10 22:09:00 | Mean, this worked: =abs(C4-AB4) | rob_on_guitar (4196) | ||
| 1 | |||||