ExcelBanter - IF NOT or IS NOT function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF NOT or IS NOT function (https://www.excelbanter.com/excel-discussion-misc-queries/32773-if-not-not-function.html)

Nick Wright

IF NOT or IS NOT function

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

"Nick Wright" <Nick wrote in message
...
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

Bob Phillips

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

--
HTH

Bob Phillips

"Nick Wright" <Nick wrote in message
...
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

All times are GMT +1. The time now is 07:01 PM.