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

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

i will try this on Monday when I get back to work, I assume I put this in
each cell. I will let you know.

Thanks

"Bob Phillips" wrote:

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