Why won't this function work?

  • Thread starter Thread starter Angelsnecropolis
  • Start date Start date
A

Angelsnecropolis

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
 
It's likely that the "330" in R4 is text. What formula is used to produce
it?

Regards,
Fred
 
Back
Top