SOLVED

Formula

Copper Contributor

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 ?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Fabio1106 

=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. 

Oh ….thank you so much….
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Fabio1106 

=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. 

View solution in original post