View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Values Returning Text

=IF(B3=30000,"Standard","Not Standard")


Gord Dibben MS Excel MVP


On Sat, 06 Jan 2007 23:22:18 GMT, "Gymclass14 via OfficeKB.com" <u26166@uwe
wrote:

I am trying to get a value in B3 of more than or equal to 30,000 to
return the word "Standard" in cell F3. I must be missing something in my
formula. Please help!! Thanks in advance.