or, another formula in A2
*=MATCH(TRUE,A1={"A","B","C","D","E"},0)*20-10*
*
*
***
*
On Thu, Oct 7, 2010 at 4:23 PM, siti Vi <villager.g...@gmail.com> wrote:
> *formula in cell A2 *
> =CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90)
> *formula in cell A3*
> =A2+10
>
>
> On Thu, Oct 7, 2010 at 1:30 PM, Dean Brown <bramfiel...@googlemail.com>wrote:
>
>> I have several questions so if it's ok with you I'll ask then one at a
>> time (that'll give me time to digest any answers).
>>
>> Ok, here's problem 1.
>>
>> I want the person using the spreadsheet to input a value into cell A1.
>> The value that is input is going to be either A,B,C,D or E. The values
>> of cells A2 and A3 will vary depending on what is input into A1.
>>
>> Basically (and in simple terms) what I want the formula to work out is
>> this:
>>
>> If A1=A then A2=10 and A3=20
>> If A1=B then A2=30 and A3=40
>> If A1=C then A2=50 and A3=60
>> If A1=D then A2=70 and A3=80
>> If A1=E then A2=90 and A3=100
>>
>> I hope this makes sense. Any help is greatly appreciated.
>>
>> Regards.
>>
>> Dean.
>>
>>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
