Simple Question.......

[bfraser]

I need to do present a Warning message if any of three cell locations have a value greater than 8, otherwise be blank. Can someone tell me what is wromg with my formula?


If(EG13>8, or EG18>8, or EG23>8,"Warning, you have exceeded the allowable limit","")

 

[jeffreybrown]

Try...

=IF(OR(EG13>8,EG18>8,EG23>8),"Warning, you have exceeded the allowable limit","")

 

[stnkynts]

If you wanted a popup box message rather than your message being put into a cell you could use vba. Something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Msg As String
 
If Target.Address = Range("EG13").Address Or Target.Address = Range("EG18").Address Or Target.Address = Range("EG23").Address Then
    If Range("EG13").Value > 8 Or Range("EG18").Value > 8 Or Range("EG23").Value > 8 Then
        Msg = MsgBox("Warning, you have exceeded the allowable limit.", vbCritical, "Warning")
    End If
End If
End Sub