Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|