• MVP Logo
  • Recent Forum Posts

    Bob Phillips

    IF Formula

    You can also do it with just simple IFs

    =IF(O2...

    Bob Phillips Today, 07:10 PM Go to last post
    pinarello

    Import Converter deletes line feeds automatically

    Hello, Ken,

    first of all, thank you for looking at my request and mentioning the possibility of text import.

    I had not even...

    pinarello Today, 04:28 PM Go to last post
    Bine

    IF Formula

    Thank you so much, the first one with the INDEX is working perfect !!! Finally!! ...

    Bine Today, 12:01 PM Go to last post
    p45cal

    IF Formula

    Try:

    Code:
    =INDEX({"Underweight";"Normal";"Overweight";"Obesity"},MATCH(O2,{0;18.5;25;30}))
    or:
    Code:
    =VLOOKUP(O2,{0,"Underweight";18.5,"Normal";25,"Overweight";30,"Obesity"},2)
    ...

    p45cal Today, 11:30 AM Go to last post
    Bine

    IF Formula

    Seems I am nearly there now with:
    =IF(O2...

    Bine Today, 11:14 AM Go to last post