How do I set up a script or something else to subtract a set number depending on how large the numbers are in the cells? For example, Id like to subtract 5 from each cell if the number in the cell is less than 50 but greater than 5 also subtract 10 if between 100-50. subtract 15 if greater than 100 but less than 150. Id like to set something up to automatically do these options for me.
Solved by S. H. in 14 mins