How to get the difference of a MINUS/subtraction function in Google Sheets

Question

I am working with a CSV file and I need 100+ numbers which are all different to equal the number 10. I would something like a cell to look like this: 76 - ("Unknown" Number) = 10

The way the CSV file is set up, the first column is the item price (e.g 79.99), and it needs to equal 69.99 in the sale column, which I am trying to edit, and it displays $10 on our site. We have different prices for each product.

Answer 1

try:

=ARRAYFORMULA(IF(A2:A="",,A2:A-10))