Notifications
Clear all
General Excel Questions & Answers
6
Posts
4
Users
0
Reactions
82
Views
Topic starter
Hi
In attached I need to add 2 columns
Running total - contains an error value (why is it an error? as it is a simple formula)
Sequence - number to reset when Running total = 0
Many thanks
Posted : 24/02/2023 11:33 am
Hi Kasey,
Nothing attached. Click Start Upload after selecting the file(s).
Phil
Posted : 24/02/2023 6:58 pm
Topic starter
Ooops! Thanks Philip
Now attached
Posted : 25/02/2023 8:42 am
The number -1.4210854715202E-14 is not an error. It's just a very very small number, very close to zero. Change the format of column F to Number with three decimals and you'll get 0.000 in F20.
Posted : 25/02/2023 9:42 am
Topic starter
Hi
I am reposting this topic as I forgot to attached doc
Please see attached
How do I add insert a formula (Sequence column) which will give the answers I have typed. The value will reset when running total = 0
Much appreciated.
Posted : 01/03/2023 6:41 am
like this
Posted : 01/03/2023 9:20 am