There are two portions to an If statement: what you want it to display if
the condition is true, and if it is false. Most people would code your If
statement as follows:

=if(b12="yes",100,200)
Now, format your cell the way you want (ie, zero decimal places, and the
dollar sign).

When you use "$100", you are creating text, which displays nicely, but you
can't do arithmetic on it. For future usefulness, you're better off using
numbers, and formatting them.

Regards,
Fred.

"ssharp" wrote in message
...
Here's my senario: I need a cell to populate a certain value if the
target
cell holds a certain value. BUT with multiple options for the target
cell.

For example, if B12=Yes, then I want B12 to say $100. HOWEVER, I also
need
if B12=NO, then I want B13 to say $200.

I can get as far as in getting the formula in to B13:

IF(B12="Yes","$100"); however I cannot figure out how to tack on the
IF(B12="NO","$200") without getting a VALUE# error...