move sum to different columns
Dn: =IF(sum_formula<=3,sum_formula,"")
En: =IF(AND(sum_formula3,sum_formula<=6),sum_formula, "")
etc.
--
__________________________________
HTH
Bob
"tkincaid" wrote in message
...
I have a total in coumn L, I need to move this total based it its size, if
equal or less than 3 it goes in column d, if less than or equal to 6 and
greater than 3 it goes in column e, then if equal to or less than 12 and
greater than 6 it goes in column f. Can this be done and how.
thanks
|