|
|
#1
06-20-2014, 01:18 PM
|
|||
|
|||
Cell equals zero or another cell in IF statement
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. 
|
|
|
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 |
Windows 8 
Office 2013
Threaded Mode