I would like to populate the F column with the following formula pulling from the same row in column E, but cant have the formula visible to the user. How can I create a macro to have the corresponding value fill in for the data set? Should I use a loop?

Any help is much appreciated.



Formula: copy to clipboard 
=IF(E2="BLANK","BLANK",IF(E2<6,"< 6 Days",IF(AND(E2>5,E2<11),"6-10 Days",IF(AND(E2>10,E2<16),"10-15 Days",IF(AND(E2>15),">15 Days")))))


Thank you,

Nick