Values Returning Text

[Gymclass14 via OfficeKB.com]

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.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Clarence Crow]

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.

try this in F3:
=IF(B3>=30000," Standard","")
works for me

-Please reply to group as my email addr is fake!

-Regards CC

 

[CLR]

Another way........

=LOOKUP(B3,{0,30000},{"Not standard","Standard"})

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

And another...........

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Range("b3").Value < 30000 Then
Range("f3").Value = "Non standard"
Else
Range("f3").Value = "Standard"
End If
End Sub


Vaya con Dios,
Chuck, CABGx3

Another way........

=LOOKUP(B3,{0,30000},{"Not standard","Standard"})

Vaya con Dios,
Chuck, CABGx3