Thread: [Solved] Formula to deal with Number and Text Fields.
View Single Post
 
Old 02-09-2021, 01:49 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
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)
Attached Files
File Type: xlsx Copy of DB RECORD COUNT(1)_Purfleet.xlsx (17.9 KB, 5 views)
Reply With Quote