Prev: SUMIF or SUMIFS help
Next: Check to see if a value exists in a list?
From: Angelsnecropolis on 11 Mar 2010 19:29
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.
From: Dennis Tucker on 11 Mar 2010 19:59
It works fine on v2007.

"Angelsnecropolis" <Angelsnecropolis(a)discussions.microsoft.com> wrote in
message news:508AD6C7-C831-4FAC-9A85-2EE1CB8165C2(a)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.

From: T. Valko on 11 Mar 2010 21:21
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(a)discussions.microsoft.com> wrote in
message news:508AD6C7-C831-4FAC-9A85-2EE1CB8165C2(a)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.


From: Fred Smith on 12 Mar 2010 00:00
It's likely that the "330" in R4 is text. What formula is used to produce
it?

Regards,
Fred

"Angelsnecropolis" <Angelsnecropolis(a)discussions.microsoft.com> wrote in
message news:508AD6C7-C831-4FAC-9A85-2EE1CB8165C2(a)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.

 | 
Pages: 1
Prev: SUMIF or SUMIFS help
Next: Check to see if a value exists in a list?