Forum Discussion
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...
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.
hynguyen,
Thank you very much for taking your time and writing the whole code. I was amazed. That was genius.
Thank you very much for taking your time and writing the whole code. I was amazed. That was genius.