|
|
#5
02-09-2021, 05:55 PM
|
|||
|
|||
Formula to deal with Number and Text Fields
Hi Purfleet, Thank You for your response. Sorry to be a pain in the butt, but I am not good at Excel Formulae. I think you have misunderstood my requirements. Please refer to my Excel Sheet that was attached.
I need the Formula to provide a Progressive Total, starting from G88 (21,384) taking into account each Row, whether it is Col C (DEL = -1) or Col D (ADD = +1), when each Row is filled. I have tested your Formula and it does not do this. Regards and Thanks. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reliable way to convert text to number with a formula | levraininjaneer | Excel | 8 | 12-22-2019 04:47 PM |
| Formula to populate column with text prefix then next number (ascending) | SerenityNetworks | Excel | 4 | 02-05-2019 07:22 AM |
| VBA to deal with Open/Replace/Save as Text file .txt | nouking | Excel Programming | 1 | 09-12-2017 12:00 AM |
| Number and Text Formula Trouble Shooting | Haha88 | Excel | 1 | 12-06-2016 11:25 PM |
 Formula, Compare two cell's text and based on results output a number
|
Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |
Windows 10 
Office 2016
Threaded Mode