How to use table filtering I want to check if a row in a table is equal to an entry

How to use table filtering I want to check if a row in the table is equal to a certain value then enter number 2010 in another column will enter another number
For example:
If the Amount
Is smaller than zero so it will fit into another column SAP in table number 2010

Amount
-200.00
352,000.00
8,460.00
42,742.00
-2,265.81
Filter column SAP code for value = 2010.
Then also filter value in column ‘Business type’ with the following values:
abc
acv
jdjd
For all the lines which remain after this filter, change the value in column SAP code to 8001 (instead of 2010 which was there before the change).