Forum Discussion

msm66's avatar
msm66
Brass Contributor
Jun 30, 2020
Solved

If statement help needed

  I am trying to write a formula for above table.  there are 3 conditions. IF ( 20 < "age cell" < 39 AND "gender cell" = "female" AND BAI < %21  THEN RESULTS = UNDERWEIGHT) And so on.  If i...
developer
excel
Formulas and Functions
  • hynguyen's avatar
    hynguyen
    Jul 01, 2020

    msm66 Please see attached workbook. I combined the check for both men and women and all age ranges and BAI range in one formula so it looks a bit long but captures every scenario you described.

msm66's avatar
msm66
Brass Contributor
Jul 01, 2020
There Is only one problem. How you were able to save it as .xlsx? it is giving me a hard time that because of macro I need to save it s .xlms
I was wondering how you were able to save it in xlsx format? thanks again
hynguyen's avatar
hynguyen
Iron Contributor
Jul 01, 2020

msm66 My Excel default is .xlsx. You can simply Save As it and choose .xlsm (or .xlsb) - both work for macro. Or just right click on the Tab "Sheet1" then choose Move or Copy... and Move the selected sheet to your xlsm workbook