IF NOT or IS NOT function

Guest · Jun 28, 2005

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 · Jun 28, 2005

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 · Jun 28, 2005

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

IF NOT or IS NOT function	3	Jun 28, 2005
Excel 2003 Question	5	Apr 15, 2009
IF Function returning range	5	Sep 15, 2008
Function to determine if a cell contains a formula	5	Mar 25, 2010
Excel code, end function?	0	Nov 5, 2017
Excel Highlighting duplicates	0	Mar 1, 2023
Functions	1	Aug 25, 2009
Function not working	5	Sep 23, 2009

IF NOT or IS NOT function

Guest

Anne Troy

Bob Phillips

Ask a Question

Similar Threads