As you said it's health first, everything else is secondary. Taking work calls will delay your recovery. Find a more considerate employer when you're fully back to health. Best wishes
Thanks for everything. I've learned loads. Especially not to include workings and formula in the main statements. The difference was a percentage in a hidden row as part of =sum total. Lesson learned.
I think part of the problem is in my closing stock calculation formula on the trading account. I've asked excel (long winded, granted), to calculate closing stock as gp% of sales , less other cost of sales to equal closing stock. This is creating a recurring decimal place issue, and I don't know how to round the formula. Could someone help me to round my formula or improve it please? Here it is (cringe) =-SUM(F16*F32)-SUM(F19:F25)+F16 where f16 is turnover, f32 is gp% f19:25.
My answers
As you said it's health first, everything else is secondary. Taking work calls will delay your recovery. Find a more considerate employer when you're fully back to health. Best wishes
I think Beta is awful at present. Previously you could cut and paste data and manipulate the data for reconciling etc. Not now.
Let he who hath not sinned cast the first calculator.
Thanks for all your comments guys. Really helpful.
R0w f20 (hidden). Doh!
Thanks
Hi Guys
Thanks for everything. I've learned loads. Especially not to include workings and formula in the main statements. The difference was a percentage in a hidden row as part of =sum total. Lesson learned.
Thanks all again
Many thanks
Hi Adam
Using pence to try and nail it bang on. Was in pound only to start, but it accumulates by high pence each month.
Thanks for your welcome comments
Hi Tom
I think I know what you mean. I've sort of found where I think the problem is further down. Basically it's a crap formula :)
Peeps
I think part of the problem is in my closing stock calculation formula on the trading account. I've asked excel (long winded, granted), to calculate closing stock as gp% of sales , less other cost of sales to equal closing stock. This is creating a recurring decimal place issue, and I don't know how to round the formula. Could someone help me to round my formula or improve it please? Here it is (cringe) =-SUM(F16*F32)-SUM(F19:F25)+F16 where f16 is turnover, f32 is gp% f19:25.
Thanks
That's my thought as well as dividends are a distribution.
Thanks