• MVP Logo
  • Recent Forum Posts

    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
    AliGW

    IF Formula

    Most probably, but it's the best I can offer without seeing your sample workbook....

    AliGW Today, 10:42 AM Go to last post
    Bine

    IF Formula

    Thank you, but unfortunately it doesnt work.. I think i do something wrong .....

    Bine Today, 10:35 AM Go to last post
    Ken Puls

    Import Converter deletes line feeds automatically

    I'll be honest, the only way I know to get around this is very ugly... it's to import the page as a text file instead of html, and do all of the parsing...

    Ken Puls Yesterday, 08:37 PM Go to last post