Maybe you mean this:

=ROUND(IF(ROUND(LEFT(A1*10^6,5)/100,0)360,ROUND(LEFT(A1*10^6,5)/100,0)/10,ROUND(LEFT(A1*10^6,5)/100,0)),0)

Regards,
Stefi

€žEric€� ezt Ã*rta:

Does anyone have any suggestions on how to set the formula?

I would like to convert any number in cell A1 into 3-digit number under 360.
If the given number is 32654 in cell A1, then 327 should be returned in cell
B1.

If the given number is 3265.4 in cell A1, then 327 should be returned in
cell B1.
If the given number is 326.54 in cell A1, then 327 should be returned in
cell B1.
If the given number is 32.654 in cell A1, then 327 should be returned in
cell B1.
If the given number is 3.2654 in cell A1, then 327 should be returned in
cell B1.
If the given number is 0.32654 in cell A1, then 327 should be returned in
cell B1.
If the given number is 0.032654 in cell A1, then 327 should be returned in
cell B1.

If the converted 3-digit number is greater than 360, then I would like to
convert it into 2-digit numbers.
If the given number is 94213 in cell A1, then 94 should be returned in cell
B1.
If the given number is 9421.3 in cell A1, then 94 should be returned in cell
B1.
If the given number is 942.13 in cell A1, then 94 should be returned in cell
B1.
If the given number is 94.213 in cell A1, then 94 should be returned in cell
B1.
If the given number is 9.4213 in cell A1, then 94 should be returned in cell
B1.
If the given number is 0.94213 in cell A1, then 94 should be returned in
cell B1.
If the given number is 0.094213 in cell A1, then 94 should be returned in
cell B1.

Does anyone have any suggestions on how to do it?
Thanks in advance for any suggestions
Eric