اسلام وعلیکم سب بھایون اور بہنوں کو

maim ms excel main ik formula likhna chahtaa hoo k agar A1 main 1 likha jay tu B1 main "pakistan" show ho aor "pakitan" par jo "hyperlink" main ney deya woh work kary agar "pakistan" show na ho to woh "hyperlink" kaam na kary

--------------
agar kesee doost ko pata he k yah formula kis trah lagy ga tu please mujh ko bta dey

thanks in advance