IF Formula Porblems
 

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...

IF Formula Porblems
 

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...

IF Formula Porblems
 

Are you referring B12 as the output cell (with formula)? Where will the input
cell be?

I think you cannot use one cell as your input and output cell.

ssharp wrote:
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...

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1