AOA. Sir Ap sub kasa hain... tu janab ma ne ik excel sheet bnani ha jis ma different currency rate hain jasa ik line $ ha tu dusri row ma pound phr rows k bad Euro ab agar ma ik ik line ma alag alag formula lagata inhe Rs. pe convert kerna k lie tu buht mushkil hu jati ha .... mujy koi esa formula btae jis ma automatically currency convert hu jae mean $ ha tu 100 se mutliply hu k amount bta da .... but mujy bar bar na kerna para ik hi dafa lagao tu jahan pound hu wahan 150 se multiply ker da jahan dusra wahan khud us amount se multiply ker da.... i think IF wala formula ban sakt ha but samjh nahi arahi kasa...... aur access ma bhi ban jae tu theak ha