Cell equals zero or another cell in IF statement

		Microsoft Office Forums > Microsoft Excel > Excel
Cell equals zero or another cell in IF statement

06-20-2014, 01:36 PM

Mjpunj

Windows 7 32bit Cell equals zero or another cell in IF statement

Office 2010 32bit

Novice

Join Date: Jun 2014

Posts: 7

=IF(ISNUMBER(SEARCH("no",O2)),"0",Q2)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to input the text of a cell into another cell automatically ？	Juliet	Excel	1	03-15-2013 03:25 AM
Change formula cell range based on cell value	Scoth	Excel	4	10-25-2012 07:51 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
IF statement that adds text to a cell	themangoagent	Mail Merge	4	08-26-2009 08:07 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:41 AM.