"IF" formula problem

  • Thread starter Thread starter ssharp
  • Start date Start date
S

ssharp

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!
 
No IFs are needed:

=(B12="YES")*100 + (B12="NO")*200
and format the cell as currency.
 
Back
Top