Re: Display single value for multiple ranges?

Tech-Archive recommends: Fix windows errors by optimizing your registry

That got it. Thanks so much!

"KL" wrote:

> Then try the following:
>
> 1) select the cell that contain the formula
> 2) go to menu Format>Cells...
> 3) on the 'Number' tab choose 'General' from the 'Category' list and hit
> 'OK'
> 4) clic inside the formula bar and hit 'Enter'
>
> Any changes?
>
> Regards,
> KL
>
>
> "Chris McDannold" <ChrisMcDannold@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:7E0B19E2-0C71-448C-A987-E96B42102AE4@xxxxxxxxxxxxxxxx
> > Sorry...no that had no effect.
> >
> > "KL" wrote:
> >
> >> Hi Chris,
> >>
> >> Does your answer mean it worked or not?
> >>
> >> Regards,
> >> KL
> >>
> >>
> >> "Chris McDannold" <ChrisMcDannold@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> >> message news:97DC272C-FE26-4DF1-8B0E-FC870F8146A7@xxxxxxxxxxxxxxxx
> >> > Yeah, I thought of that too.
> >> >
> >> > "KL" wrote:
> >> >
> >> >> Chris,
> >> >>
> >> >> Try going the menu Tools>Options, selecting the 'View' tab, and
> >> >> uncheking
> >> >> the 'Formulas' option at the bottom part of the dialog.
> >> >>
> >> >> Regards,
> >> >> KL
> >> >>
> >> >>
> >> >> "Chris McDannold" <ChrisMcDannold@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> >> >> message news:FEDAF620-8C54-4794-B27B-75186FAC05FD@xxxxxxxxxxxxxxxx
> >> >> > Wonderful! However, please see the response to Biff below as I am
> >> >> > having
> >> >> > the
> >> >> > same problem when entering your formula.
> >> >> > Thanks again!
> >> >> >
> >> >> > "KL" wrote:
> >> >> >
> >> >> >> Hi Chris,
> >> >> >>
> >> >> >> Option 1:
> >> >> >> Create a table, say in range A1:B3, like this:
> >> >> >>
> >> >> >> 20 1
> >> >> >> 30 2
> >> >> >> 40 3
> >> >> >>
> >> >> >> if in cell C1 you manually introduce a serched value, then in cell
> >> >> >> D1
> >> >> >> input
> >> >> >> the following formula:
> >> >> >>
> >> >> >> =VLOOKUP(C1,$A$1:$B$3,2)
> >> >> >>
> >> >> >> Option 2:
> >> >> >> No table necessary, just use the following formula:
> >> >> >>
> >> >> >> =VLOOKUP(C1,{20,1;30,2;40,3},2)
> >> >> >>
> >> >> >> Option 3:
> >> >> >> No table necessary, just use the following formula:
> >> >> >>
> >> >> >> =INDEX({1,2,3},MATCH(C1,{20;30;40}))
> >> >> >>
> >> >> >> Regards,
> >> >> >> KL
> >> >> >>
> >> >> >> "Chris McDannold" <Chris McDannold@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
> >> >> >> in
> >> >> >> message news:1C493305-84D8-44D1-96DB-3D6BB141F3E3@xxxxxxxxxxxxxxxx
> >> >> >> > OK, I am not sure how to even begin to search for this because I
> >> >> >> > am
> >> >> >> > unsure
> >> >> >> > of
> >> >> >> > the nomenclature I need to look for. That said, here is what I am
> >> >> >> > looking
> >> >> >> > to
> >> >> >> > understand:
> >> >> >> >
> >> >> >> > I need to display a value of "1" if a total (manually entered in
> >> >> >> > an
> >> >> >> > adjacent
> >> >> >> > cell) is 20-29; "2" if a total is 30-39; and "3" if a total is
> >> >> >> > 40+.
> >> >> >> > So
> >> >> >> > if
> >> >> >> > the
> >> >> >> > entered value is 25, the value displayed in the adjacent cell
> >> >> >> > would
> >> >> >> > be
> >> >> >> > "1".
> >> >> >> >
> >> >> >> > Can and how do I do this?
> >> >> >> > Many thanks in advance!
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • RE: file reading problem
    ... Chris ... Prev by Date: ...
    (comp.lang.fortran)
  • Re: Is it possible?
    ... I'm missing something, but I don't see what it could be? ... Regards, ... >>> the status bar. ... >>> Click in a cell containing the formula. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: excel page numbers
    ... "Tom Ogilvy" schrieb im Newsbeitrag ... Also it won't work for the OP's problem if he uses rows to repeat ... >> Regards Ron de Bruin ... >>>> want in a cell in that range. ...
    (microsoft.public.excel.programming)
  • Re: excel page numbers
    ... "Tom Ogilvy" wrote in message ... Also it won't work for the OP's problem if he uses rows to repeat> at ... >> Regards Ron de Bruin ... >>>> want in a cell in that range. ...
    (microsoft.public.excel.programming)
  • Re: working with decimal remainder
    ... Regards, ... Tom Ogilvy ... > if i have a number in a cell and i want to work with ONLY the ... Prev by Date: ...
    (microsoft.public.excel.programming)