On 2002-03-11 12:20, dneas wrote:
F2=104 but I cannot get this to work? =IF(F2<73,"Class I",IF(F2>73<100,"Class II",IF(F2>100<200,"Class III")))
On 2002-03-11 12:20, dneas wrote:
F2=104 but I cannot get this to work? =IF(F2<73,"Class I",IF(F2>73<100,"Class II",IF(F2>100<200,"Class III")))
On 2002-03-11 12:20, dneas wrote:
F2=104 but I cannot get this to work? =IF(F2<73,"Class I",IF(F2>73<100,"Class II",IF(F2>100<200,"Class III")))
On 2002-03-11 12:20, dneas wrote:
F2=104 but I cannot get this to work? =IF(F2<73,"Class I",IF(F2>73<100,"Class II",IF(F2>100<200,"Class III")))
On 2002-03-11 12:54, dneas wrote:
Anonymous - if the number is 200 it returns Class II because it is greater than 100. I think you need the OR or AND included.
This message was edited by dneas on 2002-03-11 12:55
On 2002-03-11 12:32, Anonymous wrote:
On 2002-03-11 12:20, dneas wrote:
F2=104 but I cannot get this to work? =IF(F2<73,"Class I",IF(F2>73<100,"Class II",IF(F2>100<200,"Class III")))
try this formula
=iF(F2<73,"Class I",IF(F2<100,"Class II",IF(F2<200,"Class III")))
On 2002-03-11 12:54, dneas wrote:
Anonymous - if the number is 200 it returns Class II because it is greater than 100. I think you need the OR or AND included.
This message was edited by dneas on 2002-03-11 12:55