Hi, I have a formula which I use to populate comments for my data, I am not sure why but it won't let me record this on the macro.

Basically I would like to populate all the comments begining and down (to the last cell in column B) on H14 based on below CHOOSE logic. if I do this manually it works, however I am not sure why my macro record is not working..

Any help would be greatly appreciated

Thanks so much

=CHOOSE(SUM(IF(AND(D14+0=0,E14+0=0,ABS(F14+0)>100),1),IF(AND(D14+0=0,E14+0=0,F14+0>-100,F14+0<100),2),IF(AND(D14+0<>0,E14+0<>0,D14+0=E14+0),3),IF(D14+0<>E14+0,4)),"comment 1","comment 2","comment 3","Qcomment 4")