"IF" formula problem
No IFs are needed:
=(B12="YES")*100 + (B12="NO")*200
and format the cell as currency.
--
Gary''s Student - gsnu200903
"ssharp" wrote:
Here's my scenario. I want a cell to produce a certain number if a certain
text is entered.
For example, if B12=YES, I want it to say "$100". HOWEVER, I also need it
to do if B12="NO", I want it to say "$200". I'm having a problem getting it
to do so.
I can get as far as:
IF(B12="YES","$100")
but I don't know how to add the new condition of IF(B12="NO","$200")-I just
get a "VALUE#" error!
|