Values Returning Text

  • Thread starter Gymclass14 via OfficeKB.com
  • Start date
G

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.
 
C

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.
Click to expand...

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

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

-Regards CC
 
C

CLR

Another way........

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

Vaya con Dios,
Chuck, CABGx3
 
C

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



CLR said:
Another way........

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

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Top