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

[Guest]

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

 

[Bob Phillips]

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)

 

[Ron Rosenfeld]

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