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

C1: =ROUND(B1,LOG(MAX(A1,1)))

"Eric" wrote:

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

Thank everyone very much for suggestions
Could anyone please tell me how to display it using TEXT function?
I don't need to round the number, this number is to display only.
If the cell format sets to display no decimial, then it cannot show the
decimial at all even through it contains any decimials.
Does anyone have any suggestions on how to display it using TEXT function?
Thank everyone very much for any suggestions
Eric

"Lori" wrote:

C1: =ROUND(B1,LOG(MAX(A1,1)))

"Eric" wrote:

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

TEXT is a standard Excel function.
As with every Excel function but one, Excel help explains its syntax (&
usually gives examples & references to related functions).
For TEXT:
"Converts a value to text in a specific number format.
Syntax
TEXT(value,format_text)
Value is a numeric value, a formula that evaluates to a numeric value, or
a reference to a cell containing a numeric value.
Format_text is a number format in text form from in the Category box on
the Number tab in the Format Cells dialog box.
Remarks
Format_text cannot contain an asterisk (*).
Formatting a cell with an option on the Number tab (Cells command, Format
menu) changes only the format, not the value. Using the TEXT function
converts a value to formatted text, and the result is no longer calculated
as a number."
--
David Biddulph

"Eric" wrote in message
...
Thank everyone very much for suggestions
Could anyone please tell me how to display it using TEXT function?
I don't need to round the number, this number is to display only.
If the cell format sets to display no decimial, then it cannot show the
decimial at all even through it contains any decimials.
Does anyone have any suggestions on how to display it using TEXT function?
Thank everyone very much for any suggestions
Eric

"Lori" wrote:

C1: =ROUND(B1,LOG(MAX(A1,1)))

"Eric" wrote:

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

An ugly one ;-((
=CHOOSE(MATCH(A1,{0.001;0.01;0.1;1;10;100;1000},0) ,INT(B1),INT(B1),INT(B1),INT(B1),B1-MOD(B1,0.1),B1-MOD(B1,0.01),B1-MOD(B1,0.001))
Daniel

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

=ROUND(B1,MAX(0,LOG(A1)))
--
David Biddulph

"Eric" wrote in message
...
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