hello all.
i am trying to create a formula that will consider the values in C2 and C5 (see below) and return high/moderate/low according to the parameters below
C2 can be "m" or "f", C5 is the numerical value for the ratio risk such as:
Ratio Risk High - Male>1.0 Female >0.85
Ratio Risk Moderate - Male 0.90 -1.0 Female 0.80 - 0.85
Ratio Risk Low Male <0.90 Female <0.80
the formula i have tried is from Excel, were it works, but for a reason i don't understand it is not working here, sorry, i am new to numbers.
=IF(C2="m",IF(C5>1,"high",IF(C5≥0.9,"Moderate",IF(C5<0.9,"Low")))),IF(C2="f",IF( C5>0.85,"High",IF(C5≥0.8,"Moderate",IF(C5<0.8,"Low",""))))
any help would be greatly appreciated.
many thanks
i am trying to create a formula that will consider the values in C2 and C5 (see below) and return high/moderate/low according to the parameters below
C2 can be "m" or "f", C5 is the numerical value for the ratio risk such as:
Ratio Risk High - Male>1.0 Female >0.85
Ratio Risk Moderate - Male 0.90 -1.0 Female 0.80 - 0.85
Ratio Risk Low Male <0.90 Female <0.80
the formula i have tried is from Excel, were it works, but for a reason i don't understand it is not working here, sorry, i am new to numbers.
=IF(C2="m",IF(C5>1,"high",IF(C5≥0.9,"Moderate",IF(C5<0.9,"Low")))),IF(C2="f",IF( C5>0.85,"High",IF(C5≥0.8,"Moderate",IF(C5<0.8,"Low",""))))
any help would be greatly appreciated.
many thanks