View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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.