move sum to different columns

[tkincaid]

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

 

[Bob Phillips]

Dn: =IF(sum_formula<=3,sum_formula,"")
En: =IF(AND(sum_formula>3,sum_formula<=6),sum_formula,"")

etc.

 

[tkincaid]

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