IF NOT or IS NOT function

[Nick Wright]

I am trying to do an if function so if a certain cell has certain data
nothing happens, but if the data in the cell is different a message box is
displayed.

Can anyone please help

 

[Anne Troy]

What kind of message box, Nick?
You could do something like this if the certain cell was A1...
=IF(ISBLANK(A1),"","Message")
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Bob Phillips]

Look at data validation. See http://www.contextures.com/xlDataVal01.html