ExcelBanter - "IF" formula problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - "IF" formula problem (https://www.excelbanter.com/excel-worksheet-functions/242388-if-formula-problem.html)

"IF" formula problem

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!

"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!