J
jeff
Hi,
Try this.
=IF(AND(A4>=65,A4<70),1,IF(AND(A4>=70,A4<75),2,IF(AND
(A4>=75,A4<80),3,4)))
although you'll be limited to the number of "if" tests
you can put in this formula.
jeff
want Excel to recognize that if a value is greater than
$65 but less than $70, to put 1 point in a seperate cell.
If the value is greater than $70 but less than $75 to put
2 points in a sepaerate cell. etc.
Try this.
=IF(AND(A4>=65,A4<70),1,IF(AND(A4>=70,A4<75),2,IF(AND
(A4>=75,A4<80),3,4)))
although you'll be limited to the number of "if" tests
you can put in this formula.
jeff
a value is larger than a certain number. For example, I
want Excel to recognize that if a value is greater than
$65 but less than $70, to put 1 point in a seperate cell.
If the value is greater than $70 but less than $75 to put
2 points in a sepaerate cell. etc.