Formula to deal with Number and Text Fields.

Purfleet · #1 02-09-2021, 01:49 PM

Can you just use an IF?

=IF(TRIM(C5)="DEL",J4-1,IF(TRIM(D5)="ADD",J4+1,J4+0))

You also need to tidy up the spreadsheet a bit as you have circular references, spaces after the text in Action and incorrect actions (d88)

Nasho23 · #2 02-09-2021, 05:55 PM

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