Why won't this function work?
 

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.

Why won't this function work?
 

It works fine on v2007.

"Angelsnecropolis" wrote in
message ...
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.

Why won't this function work?
 

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

=A1A2 = TRUE

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

=A1A2 = TRUE

--
Biff
Microsoft Excel MVP


"Angelsnecropolis" wrote in
message ...
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.

Why won't this function work?
 

It's likely that the "330" in R4 is text. What formula is used to produce
it?

Regards,
Fred

"Angelsnecropolis" wrote in
message ...
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.