Cell equals zero or another cell in IF statement

dirtboy · #1 06-20-2014, 01:18 PM

i am trying to use the IF statement for a cell to be 0 if another has the word no (true) or make the cell equal another if false. i keep getting an error that it recognizes = as a formula and it tells me to use an apostrophe but then it says the first character isn't valid.

Here is the IF statement i am trying to use

=IF(O2=no,0,=Q2)

any help would be greatly appreciated.

Mjpunj · #2 06-20-2014, 01:36 PM

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

Mjpunj · #3 06-20-2014, 01:42 PM

Sorry, I just saw that you wanted the cell to equal another cell if false. I hope that works for you!

dirtboy · #4 06-20-2014, 01:44 PM

works awesome. thank you very much

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