If a cell value is equal or less than a number, then the resulting value will be in a particular cell

Question

If cell C rows is between the numbers 0 - 3.9, cell D rows would input the number 7. If cell C rows are 4 - 7.9, it would input 10 on cell D rows. If cell C rows are 8 - 14.9 it would input 15 on cell D rows.

I was thinking it would be similar to:

=IF(C1>0-3.9,”7”,””)

Answer 1

use:

=IFNA(VLOOKUP(C1, {0,7;4,10;8,15}, 2, 0))