Formula for: If b6 is or = to 8333 then b6 should be 8333 HELP
 

Please help with this formual before I pull out my hair :) Also, there is a
formula in b6.

Formula for: If b6 is or = to 8333 then b6 should be 8333 HELP
 

You can't do this with a formula. If B6 is a value, you cannot put a formula
in there. You need to add it do a different cell.

=IF(B 6=8333,8333,"what should I use if less than?")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Help Me" <Help wrote in message
...
Please help with this formual before I pull out my hair :) Also, there is
a
formula in b6.

Formula for: If b6 is or = to 8333 then b6 should be 8333 HELP
 

On Fri, 6 Oct 2006 09:11:02 -0700, Help Me <Help
wrote:

Please help with this formual before I pull out my hair :) Also, there is a
formula in b6.

You cannot do that with a worksheet formula.

You can do that with an event-triggered macro.

Right Click on the sheet tab; select View Code; and paste the code below into
the window that opens.

Perhaps this will do what you wish.

==================================
Private Sub Worksheet_Change(ByVal Target As Range)
If IsNumeric([b6]) And [b6] < "" Then
[b6].Value = Application.WorksheetFunction.Min([b6].Value, 8333)
End If
End Sub
==========================


--ron