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.
|