View Single Post
 
Old 06-20-2014, 01:18 PM
dirtboy dirtboy is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2014
Posts: 2
dirtboy is on a distinguished road
Default 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.
Reply With Quote