=IF(A1360,A1/(10^INT(LOG10(A1)-1)),"")

--
__________________________________
HTH

Bob

"Eric" wrote in message
...
Does anyone have any suggestions on how to set the formula?

There is a given number 430 in cell A1, if this number is greater than
360,
then 430/10 = 43, it should return 43 in cell B1.

There is a given number 4300 in cell A1, if this number is greater than
360,
then 4300/100 = 43, it should return 43 in cell B1.

There is a given number 43000 in cell A1, if this number is greater than
360, then 43000/1000 = 43, it should return 43 in cell B1.

Does anyone have any suggestions on how to set the formula?
Thanks in advance for any suggestion
Eric