How to assign a certain value to another value, for example, in a neighboring cell?

Question

Google Sheets

Hey!

The bottom line:
From Tilda, a value falls into a google sheets table cell, and I need to assign another value to this value in the next cell.

More:
Users work with a form in Tilda and there is a dropdown field with a choice of preset values ​​of the form:

• 1-999
  
• 1000-1499
  
• 1500-1999
  
• 2000-2999
  
• Above 3000
  

The user selects one of the proposed options and submits the data. From the form, the data gets into the google sheets table. In the table, one of the above values ​​is written to the cell.

What do you need?
It is necessary that one of the values ​​selected by the user correspond to another value. Some kind of "variable designation".

Example:

- 1-999 = "16184"
- 1000-1499 = "24284"
- 1500-1999 = "32384"
- 2000-2999 = "48584"
- Above 3000 = "64800"

These numeric codes (after the equal sign) will be later read machine.

Answer 1

IFS (IFS) cell >= 3000, 64800, cell < 3000, 48584, ...
Continue by analogy.