View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SSharp SSharp is offline
external usenet poster
 
Posts: 5
Default "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!