Mar 30 2022 03:46 AM
hi ….I should realize the following conditions in the same cell
If (B7> 0.42; B8≤115); "concentric remodeling"; "concentric remodeling"; if (E (B7> 0.42; B8 > 115); "concentric hypertrophy"; "concentric hypertrophy"), if E (B7≤0.42; B8> 115); "eccentric hypertrophy"; "eccentric hypertrophy"
Could you help me ?
Mar 30 2022 04:10 AM
Solution=IF(AND(B7>0.42,B8<=115),"concentric remodeling",IF(AND(B7>0.42,B8>115),"concentric hypertrophy",IF(AND(B7<=0.42,B8>115),"eccentric hypertrophy","")))
Maybe with this formula if i correctly understand what you want to do.
Mar 30 2022 04:10 AM
Solution=IF(AND(B7>0.42,B8<=115),"concentric remodeling",IF(AND(B7>0.42,B8>115),"concentric hypertrophy",IF(AND(B7<=0.42,B8>115),"eccentric hypertrophy","")))
Maybe with this formula if i correctly understand what you want to do.