Minh co soan rat nhieu cong thuc, nhung de do vai nam sao doc lai thi cung khong hieu luon, ban nao co cach de nho khg, gop y voi ?
Minh thi thay 3 cach sau:
1/-tu Excel 2002 thi co muc Tool> Formula Auditing>Evaluate Formula
2/-Dung VBA soan lai cong thuc theo dang co cau truc, cach nay co cai do la chi co 1 so Wordsheet function moi duoc phep dung thang trong VBA va phai co 1 it kien thuc ve VBA
3/-Dung notepad chinh lai cong thuc va link vao cell co formula nay, vi du nhu
cong thuc goc: =IF(OR(LEFT(soktmay!$H21;3)=socai!$E$2;LEFT(soktmay!$I21;3)=socai!$E$2);soktmay!D21;" ")
chinh lai thanh:
=IF(
OR(
LEFT(soktmay!$H21;3)=socai!$E$2;LEFT(soktmay!$I21;3)=socai!$E$2
)
; soktmay!D21;" ")
Hien nay thi minh dang dung cach 3, thay de goi nho nhat, co the ghi chu tieng Viet them neu so quen
Luon tien gui tang ban 1 file chi dung Workshhet Formula, suu tam tren mang, lap 1 hoa don lay ten khach hang tu 1 sheet khac, ma danh sach nay co cac khoang trong, no se tu dong loai khoang trong nay
