function that can search within cell formula, not cell value

[Al Chara]

I did some research into XLM (Excel4) functions. I got a big list of the avialable functions. It is a little overwhelming.

Does anyone have a list of the most useful or helpful XLM functions?

 

[Aladin Akyurek]

On 2002-06-03 14:46, patshan wrote:

On 2002-06-03 14:43, patshan wrote:
What a great site. I am an advanced beginner and I am having trouble taking the results of a formula and rounding the number down to the nearest hundred. For instance, 1,333 would be rounded down to 1,300 and 526 would be rounded to 500. I use the paste function but keep getting the circular reference. Any help would be greatly appreciated to this self taught user.
Steve
PS
=$L$103/A12 This is a copy of the formula in question. As I said, I am an advanced beginner. Sorry for the tagging onto the original question, however I do not see a post button.

Use New Topic to start a new thread/topic.

Have a look at the FLOOR worksheet function:

=FLOOR(A1,100)

or

=FLOOR(your-formula,100)

Aladin

 

[patshan]

On 2002-06-03 14:59, Aladin Akyurek wrote:

On 2002-06-03 14:46, patshan wrote:

On 2002-06-03 14:43, patshan wrote:
What a great site. I am an advanced beginner and I am having trouble taking the results of a formula and rounding the number down to the nearest hundred. For instance, 1,333 would be rounded down to 1,300 and 526 would be rounded to 500. I use the paste function but keep getting the circular reference. Any help would be greatly appreciated to this self taught user.
Steve
PS
=$L$103/A12 This is a copy of the formula in question. As I said, I am an advanced beginner. Sorry for the tagging onto the original question, however I do not see a post button.

Use New Topic to start a new thread/topic.

Have a look at the FLOOR worksheet function:

=FLOOR(A1,100)

or

=FLOOR(your-formula,100)

Aladin


Aladin
Thank you for the quick response. Something I did not anticipate. When I round down to the nearest 100 I paint with too broad a brush. Is it possible to discriminate with above 50 round up and below 50 round down?
Steve

 

[Aladin Akyurek]

Something I did not anticipate. When I round down to the nearest 100 I paint with too broad a brush. Is it possible to discriminate with above 50 round up and below 50 round down?

Steve,

=IF(A1/100-INT(A1/100)>=0.5,CEILING(A1,50),FLOOR(A1,50))

is what you want to do?

Addendum: Substitute "($L$103/A12)" for "A1" in the above formula.

Aladin
This message was edited by Aladin Akyurek on 2002-07-17 23:52

 

[Al Chara]

First off, the post button is right next to the reply button.

Secondly, you can use the following formula:
=FLOOR($L$103/A12,100)