How does this relate to the question asked at 11:03 yesterday and answered
yesterday?

"Does anyone have any suggestions on how to set the formula?
There is a list of possible numbers in cell A1, such as
0.01, 0.1, 1, 10, 100, 1000
and there is a given number in cell B1,
If 0.01 is inputed in cell A1 and 653.456 in cell B1, then return 653 in
cell C1.
If 0.1 is inputed in cell A1 and 653.456 in cell B1, then return 653 in cell
C1.
If 1 is inputed in cell A1 and 653.456 in cell B1, then return 653 in cell
C1.
If 10 is inputed in cell A1 and 653.456 in cell B1, then return 653.5 in
cell C1.
If 100 is inputed in cell A1 and 653.456 in cell B1, then return 653.46 in
cell C1.
If 1000 is inputed in cell A1 and 653.456 in cell B1, then return 653.456 in
cell C1.

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

I don't understand where this series of almost identical questions is
leading?
--
David Biddulph



"Eric" wrote in message
...

There is a number in cell A1, which is selected from a list
0.01, 0.1, 1, 10, 100, 1000
There is a given number 654.356 in cell B1
Does anyone have any suggestions on how to display the value in different
format?
For example,
If the number in cell A1 is 0.01, then 654 should be displayed in cell C1.
If the number in cell A1 is 0.1, then 654 should be displayed in cell C1.
If the number in cell A1 is 1, then 654 should be displayed in cell C1.
If the number in cell A1 is 10, then 654.3 should be displayed in cell C1.
If the number in cell A1 is 100, then 654.36 should be displayed in cell
C1.
If the number in cell A1 is 1000, then 654.356 should be displayed in cell
C1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric