Excel 2000 This function simply does not work. This function is in Cell B2
and refers to cell A2. Cell A2 is actually a linked cell to another
worksheet so is perhaps the problem as this is a simple formula.

=IF(A2100000,"S","L")

Thank you for your assistance

Hi

If it doesn't work, what result/error are you getting?

Andy.

"donnaK" wrote in message
...
Excel 2000 This function simply does not work. This function is in Cell
B2
and refers to cell A2. Cell A2 is actually a linked cell to another
worksheet so is perhaps the problem as this is a simple formula.

=IF(A2100000,"S","L")

Thank you for your assistance

Hi Donna

Maybe the value in A2 is text. If you cannot alter it to be numeric, try
=IF(A2100000&"","S","L")


Regards

Roger Govier


donnaK wrote:
Excel 2000 This function simply does not work. This function is in Cell B2
and refers to cell A2. Cell A2 is actually a linked cell to another
worksheet so is perhaps the problem as this is a simple formula.

=IF(A2100000,"S","L")

Thank you for your assistance

On Thu, 8 Dec 2005 07:07:02 -0800, donnaK
wrote:

Excel 2000 This function simply does not work. This function is in Cell B2
and refers to cell A2. Cell A2 is actually a linked cell to another
worksheet so is perhaps the problem as this is a simple formula.

=IF(A2100000,"S","L")

Thank you for your assistance

The 10000 that you have in your formula is not identical to the 10000 that you
see in A2.

Possibilities:

The value in A2 is TEXT and not a number.
The value in A2 is being displayed as 10000 but is really something like
9999.99999986

You would have to examine the contents of A2 in order to determine which is the
case, and to devise a solution.


--ron

It returns S whether the number result of A2 is greater than or less than
100000. Perhaps the idea that Ron put forth is going in the correct
direction? That the numerical value that Excel sees in A2 is not the same
type of numerical value as the 100000 numerical value that I am specifiying
in the function?

"Andy" wrote:

Hi

If it doesn't work, what result/error are you getting?

Andy.

"donnaK" wrote in message
...
Excel 2000 This function simply does not work. This function is in Cell
B2
and refers to cell A2. Cell A2 is actually a linked cell to another
worksheet so is perhaps the problem as this is a simple formula.

=IF(A2100000,"S","L")

Thank you for your assistance

The format of the cell is number not text. Have also tried replacing = with
=, clearing all formats of the cell most basic solutions

"Roger Govier" wrote:

Hi Donna

Maybe the value in A2 is text. If you cannot alter it to be numeric, try
=IF(A2100000&"","S","L")


Regards

Roger Govier


donnaK wrote:
Excel 2000 This function simply does not work. This function is in Cell B2
and refers to cell A2. Cell A2 is actually a linked cell to another
worksheet so is perhaps the problem as this is a simple formula.

=IF(A2100000,"S","L")

Thank you for your assistance

At any rate, try
=IF(VALUE(A2)100000, "S", "L")

HTH
Kostis Vezerides

Yes! That works! Would you mind writing in English what this formula says?
I want to understand how to use it inthe future.
Thank you very much

"vezerid" wrote:

At any rate, try
=IF(VALUE(A2)100000, "S", "L")

HTH
Kostis Vezerides

It means that the values are text, nevermind the formatting, you can't
change text to number just by make sure there is a number format,
you need to trigger it by either use another formula like VALUE or a
calculation like

=IF(--A2100000, "S", "L")


or even better, copy an empty cell, select all the "number" and do
editpaste special and select add


--

Regards,

Peo Sjoblom

"donnaK" wrote in message
...
Yes! That works! Would you mind writing in English what this formula
says?
I want to understand how to use it inthe future.
Thank you very much

"vezerid" wrote:

At any rate, try
=IF(VALUE(A2)100000, "S", "L")

HTH
Kostis Vezerides