Can anyone help me? I doing the price, there is two processes, first I have
to calculate the USD to my country's currency then I have to round up or down
the price. I need the price end with 500, 700, or 900 without decimal.

The way to round the price is like this.

0-299 round down to 900 ex: 3250 round to 2900
300-599 round to 500 ex: 4365 round to 4500 if 5580 round to 5500
600-700 round to 700 ex: 8600 round to 8700
799-900 round to 900 ex: 4800 round to 4900
901-000 round to 900 ex: 3980 round to 3900

thank you in advance

You need to round the number down to the nearest 1000. Then look up get the
value between 0 to 999 and perform a lookup using the lowest number of your
range. The lookup value is then added/subtract to the rounddown value


=ROUNDDOWN(D4,-3)+LOOKUP(MOD(D4,1000),{0,300,600,799;-100,500,700,900})

"Ms. Latte" wrote:

Can anyone help me? I doing the price, there is two processes, first I have
to calculate the USD to my country's currency then I have to round up or down
the price. I need the price end with 500, 700, or 900 without decimal.

The way to round the price is like this.

0-299 round down to 900 ex: 3250 round to 2900
300-599 round to 500 ex: 4365 round to 4500 if 5580 round to 5500
600-700 round to 700 ex: 8600 round to 8700
799-900 round to 900 ex: 4800 round to 4900
901-000 round to 900 ex: 3980 round to 3900

thank you in advance