Re: Nested IF(AND is not working

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Thu, 23 Jun 2005 13:20:02 -0700, "Todd F." <ToddF@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

>I searched & searched for an old post to cover this but nothing out there.
>
>I have the following formula that is got an error in it:
>
>=IF(I2<30, "< 30"), IF(AND(I2>=30, I2<=60),"31-60"), IF(AND(I2>60,
>I2<=90),"61-90"), IF(I2>=91, "> 91")
>
>my goal is tot have the following for statements placed in a cell via this
>calculation to cover 4 possible variables.
>
>if number is then or equal to 30 then tag "<30"
>if number is 31 or greater and 60 or less then tag "31-60"
>if number is greater then 60 but less then or equal to 90 then tag "61-90"
>if number is greater then or equal to 91 then tag "91+"
>
>I use to do these all the time what is up with this formula:
>
>Thanks Todd Frisch tfrisch9@xxxxxxxxxxx
>

Try:

=VLOOKUP(A2,{0,"<30";31,"31-60";61,"61-90";91,"91+"},2)


--ron
.

Relevant Pages

  • range function
    ... i am trying to create a function that will change the calculation of each ... cell in a range. ... For Each c In TheRange ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: coping formulas from one cell to another
    ... Probably you're calculation is set to manual, or you have another workbook ... but also the value that was in the copied cell. ... Prev by Date: ...
    (microsoft.public.excel.setup)
  • Re: storing and reusing a value?
    ... Put =VLOOKUPin a cell say H1 and use ... > temporary name/variable and reuse it by calling that variable instead of ... > doing the calculation again? ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: SUMPRODUCT by Date (numeric) value
    ... were in each cell ... "Aladin Akyurek" wrote: ... The following calculation I have is not working on ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: request code for right align and percentage
    ... Rangemeans you want to place your answer in Cell B3. ... you want the result of your calculation to go? ... "srinivasan" wrote: ... Prev by Date: ...
    (microsoft.public.excel.programming)