Thread: Why won't this function work?

It works fine on v2007.

"Angelsnecropolis" <Angelsnecropolis@discussions.microsoft.com> wrote in
message news:508AD6C7-C831-4FAC-9A85-2EE1CB8165C2@microsoft.com...
> This function works:
> =IF(B71="","",IF(B71<=330,"Standard","Below Standard"))
>
> But when I change "330" to "R4" it doesn't work. R4 is a number field that
> has 330 in it. It doesn't seem to be recognizing the Value_if_False
> statement. Any number will make it show "Standard."
> =IF(B71="","",IF(B71<=R4,"Standard","Below Standard"))
>
> Your help is appreciated.

Does R4 contain a formula?

If R4 contains a *text* number and B71 contains a numeric number then
B71<=R4 will *always* be TRUE because in Excel text has a higher value than
numeric numbers.

A1 = X
A2 = 1,000,000

=A1>A2 = TRUE

A1 formatted as TEXT
A1 = 1 (a text number)
A2 = 1,000,000

=A1>A2 = TRUE

--
Biff
Microsoft Excel MVP


"Angelsnecropolis" <Angelsnecropolis@discussions.microsoft.com> wrote in
message news:508AD6C7-C831-4FAC-9A85-2EE1CB8165C2@microsoft.com...
> This function works:
> =IF(B71="","",IF(B71<=330,"Standard","Below Standard"))
>
> But when I change "330" to "R4" it doesn't work. R4 is a number field that
> has 330 in it. It doesn't seem to be recognizing the Value_if_False
> statement. Any number will make it show "Standard."
> =IF(B71="","",IF(B71<=R4,"Standard","Below Standard"))
>
> Your help is appreciated.