check value in first column and write in the next column

hi

i have an excel sheet with 3 columns as attached .

i need a program to do the following:

checkif the value in column 2 is between 2 specific values (example:10< x = 15 ) then it will write in the third column specific value . and this will be repeated for more than one case.

thanks

thanks stnkynts , this exactly what i need

this will check only if the cell > 10 so it will write 15, if i want to check with two ranges for example i want to check if x is between 10 and 15 then write 15 if not it will continue to check for another criteria for example x is between 15 and 20 then write 20

Correct, I just created it exactly as you described in your first post. Here is code to address the examples as written in your most recent post. You should be follow it so you can add different criteria as needed.

Please Login or Register  to view this content.

thanks , this solved my issue