Excel Conditional Formatting For Rounding Numbers

[ixcoapeado]

Hi, i have the following numbers:

835 840 845 850 855 900 905 910 915 920 925 930 935 940 945 950 955 1000 1005 1010 1015 1020 1025 1030 1035 1040 1045 1050 1055 1100 1105 1110 1115 1120 1125 1130 1135 1140 1145 1150 1155 1200 1205 1210 1215 1220 1225 1230 1235 1240 1245 1250 1255 1300 1305 1310 1315 1320 1325 1330 1335 1340 1345 1350 1355 1400 1405 1410 1415 1420 1425 1430 1435 1440 1445 1450 1455 1500

I want them to be rounded to its nearest higher value:

930 1030 1130 1230 1330 1430 1500 930 1030 1130 1230 1330 1430 1500 930 1030 1130 1230 1330 1430 1500

Example: =IF(A1="930,1030,1130,1230,1330,1430,1530", then A1, If not, find its nearest value between 930,1030,1130,1230,1330,1430,1530)

Thanks in advance…

[Chance2]

Try this..

=LOOKUP(A1,{0,931,1031,1131,1231,1331,1431,1501},{930,1030,1130,1230,1330,1430,1500})

Where the first string needs 0 and +1 to have a range.
You could also have these values as ranges.

[ixcoapeado]

Thanks!!! It worked