Does anyone have any suggestions on how to do it in excel?

There is a list of odd numbers under A column
1,3,5,7,9,...
When I input any number in cell B1, such as 7.8, then it should return 7 in
cell C1, because 7.8 is closer to 7 than 9.
When I input any number in cell B1, such as 8.1, then it should return 9 in
cell C1, because 8.1 is closer to 9 than 7.
When I input any number in cell B1, such as 8, then it should return 7 in
cell C1, because it is my preference.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Are the values desired in column C related in any way to the data present in
column A ?
--
Gary''s Student


"Eric" wrote:

Does anyone have any suggestions on how to do it in excel?

There is a list of odd numbers under A column
1,3,5,7,9,...
When I input any number in cell B1, such as 7.8, then it should return 7 in
cell C1, because 7.8 is closer to 7 than 9.
When I input any number in cell B1, such as 8.1, then it should return 9 in
cell C1, because 8.1 is closer to 9 than 7.
When I input any number in cell B1, such as 8, then it should return 7 in
cell C1, because it is my preference.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

try this (quite long - i bet there is a shorter solution!)

=IF((B3-(ODD(B3)-2))<1,ODD(B3)-2,(IF((B3-(ODD(B3)-2))1,CEILING(B3,1),(ODD(B3)-2))))

hope this helps,
michelle

"Eric" wrote:

Does anyone have any suggestions on how to do it in excel?

There is a list of odd numbers under A column
1,3,5,7,9,...
When I input any number in cell B1, such as 7.8, then it should return 7 in
cell C1, because 7.8 is closer to 7 than 9.
When I input any number in cell B1, such as 8.1, then it should return 9 in
cell C1, because 8.1 is closer to 9 than 7.
When I input any number in cell B1, such as 8, then it should return 7 in
cell C1, because it is my preference.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

such as 8, then it should return 7 in
cell C1, because it is my preference.

I may be wrong, but I think this is correct...

=ODD(A1-1)

--
HTH :)
Dana DeLouis


"Eric" wrote in message
...
Does anyone have any suggestions on how to do it in excel?

There is a list of odd numbers under A column
1,3,5,7,9,...
When I input any number in cell B1, such as 7.8, then it should return 7
in
cell C1, because 7.8 is closer to 7 than 9.
When I input any number in cell B1, such as 8.1, then it should return 9
in
cell C1, because 8.1 is closer to 9 than 7.
When I input any number in cell B1, such as 8, then it should return 7 in
cell C1, because it is my preference.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric