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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1

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

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.

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

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

-Regards CC

Another way........

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

Vaya con Dios,
Chuck, CABGx3


"Gymclass14 via OfficeKB.com" <u26166@uwe wrote in message
news:6be63b6f9aa5d@uwe...
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1

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" wrote in message
...
Another way........

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

Vaya con Dios,
Chuck, CABGx3


"Gymclass14 via OfficeKB.com" <u26166@uwe wrote in message
news:6be63b6f9aa5d@uwe...
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1