Function not working

D

donnaK

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(A2>100000,"S","L")

Thank you for your assistance
 
R

Roger Govier

Hi Donna

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


Regards

Roger Govier
 
R

Ron Rosenfeld

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(A2>100000,"S","L")

Thank you for your assistance
Click to expand...

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
 
D

donnaK

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?
 
D

donnaK

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

donnaK

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
 
P

Peo Sjoblom

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(--A2>100000, "S", "L")


or even better, copy an empty cell, select all the "number" and do
edit>paste special and select add
 
Top