ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
I am trying to do a sum calculation but fell at the first fence.
Please can you advise how i can achieve the following.
I would enter a value in cell K5
In cell E14 is where the calculation / answer will be placed.
Example
I enter 123 in cell K5 & the calculation in cell E14 is =SUM(K5)-65 I then expect to see 58 in cell E14 but i keep seeing -65 in cell A14
Please advise what ive done wrong & how to do it correctly
Thanks
I am trying to do a sum calculation but fell at the first fence.
Please can you advise how i can achieve the following.
I would enter a value in cell K5
In cell E14 is where the calculation / answer will be placed.
Example
I enter 123 in cell K5 & the calculation in cell E14 is =SUM(K5)-65 I then expect to see 58 in cell E14 but i keep seeing -65 in cell A14
Please advise what ive done wrong & how to do it correctly
Thanks