Thread: Why won't this function work?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dennis Tucker Dennis Tucker is offline
external usenet poster
  
Posts: 140
Default 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.

Reply With QuoteReply With Quote