# Easy one? Is there a "When" like argument?

1. ## Easy one? Is there a "When" like argument?

Here is an easy one for someone smarter than I: If Cell A1=2 and Cell B1=2 and Cell C1=A1+B1, currently equally 4. I am trying to find or create a formula in Cell D1 that would argue:D1=WHEN(A1=10,C1=12) I am trying to get a 12 kicked out in the above scenario. This is similar to an IF statement, but if you plug IF in we know it will return a false value. Any ideas or solutions?

2. ## RE: Easy one? Is there a "When" like argument?

try in d1: =if(and(a1=10,c1=12),12,"some other item")
--
HTHs Martin

"xcelentform" wrote:

>
> Here is an easy one for someone smarter than I: If Cell A1=2 and Cell
> B1=2 and Cell C1=A1+B1, currently equally 4. I am trying to find or
> create a formula in Cell D1 that would argue:D1=WHEN(A1=10,C1=12) I am
> trying to get a 12 kicked out in the above scenario. This is similar to
> an IF statement, but if you plug IF in we know it will return a false
> value. Any ideas or solutions?
>
>
> --
> xcelentform
> ------------------------------------------------------------------------
> xcelentform's Profile: http://www.excelforum.com/member.php...o&userid=16889
>
>

3. ## Re: Easy one? Is there a "When" like argument?

=IF(OR(A1=10,C1=12),...

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"xcelentform" <xcelentform.223t2n_1138047004.215@excelforum-nospam.com>
wrote in message
news:xcelentform.223t2n_1138047004.215@excelforum-nospam.com...
>
> Here is an easy one for someone smarter than I: If Cell A1=2 and Cell
> B1=2 and Cell C1=A1+B1, currently equally 4. I am trying to find or
> create a formula in Cell D1 that would argue:D1=WHEN(A1=10,C1=12) I am
> trying to get a 12 kicked out in the above scenario. This is similar to
> an IF statement, but if you plug IF in we know it will return a false
> value. Any ideas or solutions?
>
>
> --
> xcelentform
> ------------------------------------------------------------------------
> xcelentform's Profile:

http://www.excelforum.com/member.php...o&userid=16889
>

4. Thanks for the responses, but both replies override the computation in C1. To clarify: I am trying to do a virtual array without physically changing the table. C1 should always equal A1+B1, it's just that I am trying to temporarily plug a different value in A1 and find out temporarily what C1 would compute. I have a sheet that has over 30,000 programed cells and I do not want to write parrelel pages to run this rather simple type of equation.

5. ## Re: Easy one? Is there a "When" like argument?

Take a look at the Solver feature which may be of use here.

6. Some more clarification: A1 always equals 2, B1 always equals 2, C1 always equals (A1+B1) Here is the corected qustion D1 is asking: D1=C1 WHEN(A1=E1). E1 is a typed in value that could be changed, thus D1 would spit out a different number. If E1=10, then accordingly you would get 12. The reason I say A1 always equals 2 is because that is a chart and I do not want to change the chart. D1 is simply asking "if it were changed, what would C1 be", without actually changing the chart. The chart would still use all of it's formulas as it normally would do. The "10" in the formula for D1 would be E1, so if someone pluged in a 100 for E1, this D1 would return 102. Hope this helps.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1