T
teachertwish
I'm trying to use the formula below, but it seems that it is too long for
Excel 97-2004. The formula works for Mac 2008 or Vista versions of Office,
but not in lower versions. My colleague only has a lower version and she
needs to use the file I need to send her. The formula only works when I
delete conditions from IF(D25>14....)
=IF(D25>29,100,IF(D25>27,99,IF(D25>25,98,IF(D25>23,97,IF(D25>21,96,IF(D25>19,95,IF(D25>17,94,IF(D25>14,93,IF(D25>12,
92,IF(D25>10,91,IF(D25>8,90,IF(D25>6,89,IF(D25>4,88,IF(D25>2,87,IF(D25>0,86,IF(D25=0,85))))))))))))))))
Excel 97-2004. The formula works for Mac 2008 or Vista versions of Office,
but not in lower versions. My colleague only has a lower version and she
needs to use the file I need to send her. The formula only works when I
delete conditions from IF(D25>14....)
=IF(D25>29,100,IF(D25>27,99,IF(D25>25,98,IF(D25>23,97,IF(D25>21,96,IF(D25>19,95,IF(D25>17,94,IF(D25>14,93,IF(D25>12,
92,IF(D25>10,91,IF(D25>8,90,IF(D25>6,89,IF(D25>4,88,IF(D25>2,87,IF(D25>0,86,IF(D25=0,85))))))))))))))))