*formula in cell A2 *
=CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90)
*formula in cell A3*
=A2+10On 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
